Fixed Adding an identity to an existing column #dev #it #asnwer
Fixed Adding an identity to an existing column #dev #it #asnwer
Adding an identity to an existing column
I need to change the primary key of a table to an identity column, and there’s already a number of rows in table.
I’ve got a script to clean up the IDs to ensure they’re sequential starting at 1, works fine on my test database.
What’s the SQL command to alter the column to have an identity property?
Answer: Adding an identity to an existing column
You…
View On WordPress


















