RSS‎ > ‎

SQL :: What is Identity?

posted Sep 17, 2012, 10:10 PM by Ashish Jain
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 controled. Identity/GUID columns do not need to be indexed.