Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.identity_columns (Transact-SQL)

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.

Community Additions

ADD
Show:
© 2015 Microsoft