Clever Geek Handbook

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


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


source






More articles:


All Articles