Home > DeveloperSection > Interviews > What is Identity?

Posted on    August-12-2011 1:57 AM

 MSSQL Server MSSQL Server 
Ratings:
 2 Answer(s)
  1625  View(s)
Rate this:

Chris Anderson
Chris Anderson

Total Post:197

Points:985
Posted on    August-12-2011 12:00 AM

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 controlled. Identity/GUID columns do not need to be indexed.


Amit Singh

Total Post:565

Points:2825
Posted on    September-28-2011 12:00 AM

Creates an identity column in a table. This property is used with the CREATE TABLE & ALTER TABLE Transact-SQL statements.

Don't want to miss updates? Please click the below button!

Follow MindStick