SQL Server Management Studio Error: Saving changes is not permitted.

Posted by: David Hill on June 12, 2018

SQL Server Management Studio

Error: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. What to do: Tools > Options > Designers > Table and Database Designers. See the checkbox: "Prevent saving changes that require the table to be re-created". Uncheck it.