Tangara G

Tangara G

  • NA
  • 298
  • 89.7k

how to make an existing table field auto-increment in MsSQL

Sep 11 2016 4:43 AM
hi,
 
 
I am using Ms SQL 2014.
 
Please find below the table I have created.
 
 
 
My problem is that I do not know how to make my primary key auto-increment from here.
 
There isn't a script file for me to load, to my surprise.
 
Another thing is that I have 2 copies of MS SQL - one is the SQLExpress and the other one is the main one.  Not sure why it is so.
 
Hope someone can advise me on the above. Tks.

Answers (5)