Amending a SQL table without getting “Saving changes is not permitted”

When I come to amend a table in SQL Server all is fine until you come to save the new structure you end up getting the following message:

“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.”

This is happening because ““Prevent saving changes that require table re-creation” option is enabled.  You can disable this by going into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”, this is either in Visual Studio or SQL Management Studio.

Now you can apply your new changes to the table