lundi 6 mars 2017

how to add Identity (autoincrement ) on the column of existing created table in sql server? [duplicate]

This question already has an answer here:

Without adding a new column can we update in the existing column?

I have created a table create table SalesInfo (Sales_ID int Not Null , Product_ID int Not Null , Sales_Status varchar(50) , Remarks varchar(200));

Thus in this table, want to add auto-increment to Sales_ID without deleting the existing column is there any solution ??

Aucun commentaire:

Enregistrer un commentaire