Identity is a basically called as AutoNumber. It is mainly a column that automatically generates numeric values. When A start and increment value can be set, but most DBA leave these at 1. A identity or GUID column also generates numbers; these type of values cannot be controlled. Identity/GUID columns do not need to be indexed.