Monday, May 8, 2017

Identity Specification (Is Identity) SQL Server Table

Saving Changes is not Permitted. Tables need to be dropped and re-created. Message is appeared while you try to change the (Is Identity) Column  Property of a table.

How to make a change without dropping the table.
Follow the below steps.


Go to Tools>Options>Designers> Un-check Prevent Saving changes that requires table re-creation.