Identity (SQL)
From Clinfowiki
Identity is a special property that is used in some SQL languages such as Transact-SQL.
Contents
Usage
This property “creates an identity column in a table. This property is used with the CREATE TABLE and ALTER TABLE Transact-SQL statements.”[1][2] This column can automatically generate numeric values.[3]
“Identity Key”
This term is most used in acknowledgement that Identity can be used as a primary key. However, it is suggested that Identity not be used as a primary key unless in specific circumstances.[3]