Identity column allows the insertion of incremental values in a particular column whenever a row is inserted in the table. We can define the initial value and the seed value as well when declaring an identity column.
When
a new row is created in a table with Identity Column, the Identity
Column value for inserted row is generated by the system automatically. A
table can have only one identity column.