What is Identity?

What is Identity?

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.

Date:2010-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher