Identity (SQL)

From Clinfowiki
Jump to: navigation, search

Identity is a special property that is used in some SQL languages such as Transact-SQL.


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]

For More Information

Identity and Primary Keys

Identity According to Microsoft

References

  1. https://msdn.microsoft.com/en-us/library/ms186775.aspx
  2. https://technet.microsoft.com/en-us/library/aa933196(v=sql.80).aspx
  3. 3.0 3.1 http://www.sqlteam.com/article/identity-and-primary-keys