Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft