Adding Identity to existing column with data in Sql Server

Asked Jul 15 '16 at 19:36

Active Nov 16 '16 at 21:15

Viewed 2,596 times

I have a table with 4 million records. I want to change orderid to Identity without losing the data.

Is it possible?

edited Nov 16 '16 at 21:15

asked Jul 15 '16 at 19:36

neoo

http://stackoverflow.com/questions/1049210/adding-an-identity-to-an-existing-column – TheGameiswar Jul 15 '16 at 19:44
2

See the second answer in the dupe. This is the lowest impact method. – Martin Smith Jul 15 '16 at 19:45

0 Answers0