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.

Leave a Reply

Your email address will not be published. Required fields are marked *