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 Use Sparse Columns. |
|
is_column_set |
bit |
1 = Column is a column set. For more information, see Use Column Sets. |
Note
|
|---|
|
To create an automatically incrementing number that can be used in multiple tables or that can be called from applications without referencing any table, see Sequence Numbers. |
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.
