Retrieves the identity column's type, whether it is a non-globally-unique identity column or a globally-unique identity column.
- Remarks:
- Non-globally-unique identity columns have their value automatically populated by SQL Server on insert; the first value is set to the specified IdentitySeed, and all subsequent values are set using the specified IdentityIncrement. If defining such a column during ApplySchema, it must be one of the following SQL Server native data types: decimal, int, numeric, smallint, bigint, or tinyint. Note that the not for replication identity column flag is not exposed. Also note that the identifier column must not be nullable and must not contain a default value. Globally-unique identity columns do not have their value automatically populated by SQL Server. Instead SQL Server relies on the default value or the user to populate this value. To have this value populated automatically on insert, the user should set the default value to use the NEWID() function to obtain a globally-unique identity value. This override is ignored on ApplySchema if this column belongs to an existing table in a foreign database. This override is also ignored if IdentityPropertyName is not specified.
- Returns:
- Returns the type of the single IDENTITY column, if it exists