Home > DeveloperSection > Interviews > What is Identity?

Posted on    August-12-2011 1:57 AM

 MSSQL Server MSSQL Server 
 2 Answer(s)
  1583  View(s)
Rate this:

Chris Anderson
Chris Anderson

Total Post:197

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

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