Share via


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.