Identity: A numerical value automatically assigned to a row any time a new row is added. : Identity « Sequence Indentity « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Sequence Indentity
3. Identity

4>
5> CREATE TABLE MyTable (
6> MyID Int IDENTITY(1, 1) NOT NULL
7> , MyDescription nVarChar(50) NOT NULL)
8> GO
1>
2> drop table MyTable;
3> GO
1>

The actual syntax for the IDENTITY property is as follows:
IDENTITY [ (seed , increment ) ]

4>