Answer: SQL Server add auto increment primary key to existing table

answer re: SQL Server add auto increment primary key to existing table

Feb 1 '11

477

No - you have to do it the other way around: add it right from the get go as INT IDENTITY - it will be filled with identity values when you do this:

ALTER TABLE dbo.YourTable
   ADD ID INT IDENTITY

and then you can make it the primary key:

ALTER

…

Open Full Answer