alter table my_table add [my_new_id] [int] IDENTITY(1,1);
alter table my_table add constraint pk_my_id primary key(my_new_id);
if you already have a primary key, just remove that and add this new primary key.
alter table my_table add [my_new_id] [int] IDENTITY(1,1);
alter table my_table add constraint pk_my_id primary key(my_new_id);
0 comments:
Post a Comment