What do you mean by Identity
| Identity is a column that automatically generates numeric values.We can start and increment value can be set but most DBA leave these at one. A GUID column also generates numbers the value of this cannot be controlled. Identity/ GUID columns do not need to be indexed. | |