Allow Saving Changes To Tables in SQL Server Management Studio
When attempting changes to Table structure via SQL Server Management Studio (SSMS), you may encounter an error:
“Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created.
You have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created.”
The fix is to disable the ‘Prevent saving changes that require table re-creation’ in the options dialog.