SQL Server Management Studio (SSMS) – Save changes made to a Table

Seamless Integration

SQL Server Management Studio (SSMS) – Save changes made to a Table

SSMS will prevent any changes being made to the table through the ‘Design’ mode:

You will see the following error appear that prompts us to drop and re-create table:

This restriction is set by SSMS from accidental changes on the table structure. However, if you are certain the changes are intended, you can overcome this by going to Tools>Options>Designers>Table and Database Designers and uncheck the ‘Prevent saving changes that require table re-creation checkbox:

No Comments

Add your comment

7 − two =