How do I add the IDENTITY property to an existing SQL Azure table?
I created a couple of tables in SQL Azure and forgot to mark the primary keys as columns identity
. There is no data in the tables yet, but the checkbox with the caption is Is Identity
disabled.
How do I create an existing primary key on a column identity
in SQL Azure?
+3
Feckmore
source
to share
1 answer
A new table is created. You can't change the IDENTITY property on a regular SQL Server instance - well, depending on your settings, SSMS might let you, but it doesn't tell you what it actually does behind the scenes - drops the table and re-creates it. Don't believe me? Script it or profile.
+5
Aaron bertrand
source
to share