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.
See Also