Difference between revisions of "Identity (SQL)"
From Clinfowiki
(Creation of new page, with Definition and References) |
(No difference)
|
Latest revision as of 04:47, 22 November 2015
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]