What is Identity?
Identity is a bassically 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; thease type of values cannot be controlled. Identity/GUID columns do not need to be indexed.