Friday 3 June 2011

How to create a table with identity column?

      • create table my_table (my_id int identity (1,1),first_name       varchar(20),last_name varchar(30));
      • Above command creat table my_table with my_id identity column
      • squence or identitiy start with 1 and also increamented value by 1 each and every insertion operation on table .
      • this identity column vaue is forward only .

No comments:

Post a Comment