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

When you try to make change in table design using SQL Server Management Studio, the above error comes. This is default setting of SQL Server SSMS that it doesn’t allow user to modify the schema of table and throws the message on saving. The setting is “Prevent saving changes that require table re-creation”. It can be changed through SSMS.

Start SQL Server Management Studio

Go to Tools menu than choose Option

Click Designers > Table and Database Designers

Now uncheck the option: “Prevent saving changes that required table re-creation.”

Click Ok.