WHAT IS IDENTITY?

Chris Anderson

Total Post:197

Points:985
Posted by  Chris Anderson
 1855  View(s)
Ratings:
Rate this:
  1. Chris Anderson

    Post:197

    Points:985
    What is Identity?

    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.

  1. Amit Singh

    Post:565

    Points:2825
    What is Identity?

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!