IDENTITY

IDENTITY

--=========================================[IDENTITY]==================================================================

--This is used when we would like the value of the primary key field to be created automatically

--every time a new record is inserted.

--Identity---

CREATE TABLE employee(

     ID          int PRIMARY KEY IDENTITY,

     name        nvarchar (10),

     salary      int,

     start_date  datetime,

     city        nvarchar (10),

     region      char (1))