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

Reference

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Other Resources

Querying the SQL Server System Catalog FAQ

Help and Information

Getting SQL Server 2005 Assistance