Solved: Saving changes is not permitted. The changes you have made...

If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:

“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”

All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.

Follow the screenshot below to disable it.

In the Tools menu click Options.

Click Designers >> Table and Database Designers.

Uncheck Prevent saving changes that require table re-creation.

Click OK to save the changes.