sys.identity_columns (Transact-SQL)

sys.identity_columns (Transact-SQL)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

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.
is_computed	bit	Identity column is a computed column.
is_sparse	bit	1 = Column is a sparse column. For more information, see Using Sparse Columns.
is_column_set	bit	1 = Column is a column set. For more information, see Using Column Sets.

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Reference

Other Resources

Help and Information