What is Identity?

Posted by

To view Verified answers click on the button below.

Ans: 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.