How can a column in SQL table made as Identifier column

IDENTITY  property

Identified column can be implemented using IDENTITY property. While specifying IDENTITY column, you specify SEED and ARGUMENT.


IDENTITY [ (seed , increment) ]

When inserting rows into table with IDENTITY column , SQL Server automatically generates next identity value by adding increment to previous identity value.


  1. Only one column in a SQL table can be defined with IDENTITY property.
  2. IDENTITY column can be defined on decimal , int , numeric , smallint , bigint or tinyint data type column.
  3. Default increment value is 1
  4. Identity value is assigned in ascending order by default
1. Create a table with IDENTITY column using create table script

EmpNumn int IDENTITY(1,1),
Name varchar (200),
Email varchar(100)

2. Identity column using SQL Server Enterprise Manager

Leave a Reply