Forum Discussion
Alter a primary key column as IDENTITY
Hi there, I have a SQL Server table named Users (ID, Name, LoginDate, Password, Email) with some records in it. But when I created it I forgot to Auto Increment its ID which is the primary key. N...
mesan98, you can not alter an existing column to IDENTITY.
You have to either recreate the table or add an additional column with IDENTITY property.
Olaf