SQL Server

Saving Changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

In SQL Server if you attempt to modify a table structure through the Table Designer you would encounter this error.

SQLServerScreen1

 

There is a simple fix for it.

 

Step 1 Go to Tools > Options

SQLServerScreen2

 

 

Step 2

Go to Designer > Table and Database Designers

and Untick the option

SQLServerScreen3

 

Step 3: Now you should be able to save the changes to your tables.