sys.identity_columns (Transact-SQL)

Contains a row for each column that is an identity column.

Column name	Data type	Description
<columns inherited from sys.columns>		For a list of columns that this view inherits, see sys.columns (Transact-SQL).
seed_value	sql_variant	Seed value for this identity column. The data type of the seed value is the same as the data type of the column itself.
increment_value	sql_variant	Increment value for this identity column. The data type of the seed value is the same as the data type of the column itself.
last_value	sql_variant	Last value generated for this identity column. The data type of the seed value is the same as the data type of the column itself.
is_not_for_replication	bit	Identity column is declared NOT FOR REPLICATION.

See Also