In the reference section for the select command, a bulleted item describes how to add a new IDENTITY column and use precision to specify the numeric datatype:
A specification to add a new IDENTITY column to the result table:
column_name = identity(precision)
Beginning with Adaptive Server Enterprise version 12.5.4, you can specify the IDENTITY column with int, smallint, and tinyint as well as precision.
A specification to add a new IDENTITY column to the result table:
column_name = identity(int | smallint | tinyint | precision)
If you specify int, smallint, or tinyint, the resulting column is an integer. If you specify precision, the result is a numeric datatype.
