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.
