yes that s IDENTITY See the example : CREATE TABLE Emp (EMPID int IDENTITY (1, 1) NOT NULL ,EMPNAME VARCHAR(20)) Above this examble Identity is like an auto increment. The Parameters (1,1) represents Start Number, Increment Number this example starts 1 and next incremented by 1
RK