What is Identity?

Question

What is Identity?

Amit Singh · Answer

Creates an identity column in a table. This property is used with the CREATE TABLE and ALTER TABLE Transact-SQL statements.

Chris Anderson · Answer

Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers; the value of this cannot be controlled. Identity/GUID columns do not need to be indexed.

interview

What is Identity?

Can you answer this question?

2 Answers