- 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