Change column to an autoincrement field

[j252ewv]

I have a table which has a primary key,this key although numeric is not auto increment but is unique, I need to convert this column to an autoincrement field, can some ome help me with the tsql to achieve this.

 

[markros]

You need to calculate the max of the number, create a new column with identity field starting from Max+1

insert data from your original table into this new one using

SET IDENTITY_INSERT ON -- check syntax in BOL

and after everything is done, you can delete your original table and rename the new one to the old.



PluralSight Learning Library