Identity Attribute

The driver exposes the SQL Server Identity Attribute using the SQL_COLUMN_AUTO_INCREMENT descriptor in SQLColAttributes and the AUTO_INCREMENT column in the SQLGetTypeInfo results set. SQL Server treats identity as an attribute, whereas ODBC treats it as a datatype. To resolve this mismatch, SQLGetTypeInfo returns the following new datatypes:

• int identity
• smallint identity
• tinyint identity
• decimal identity
• numeric identity