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.
|
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
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Other Resources
Querying the SQL Server System Catalog FAQ
Help and Information
Getting SQL Server 2008 Assistance