Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.