Identity column is a column whose value increases automatically as and when data is inserted into the table. The value in an identity column is created by the server. A user cannot insert a value into an identity column; it’s created by the server.
Identity column can be used to uniquely identify the rows in the table and acts like a primary key field.
Want More SQL Deep Dives