Sql Server 'Saving changes is not permitted' error Prevent saving changes that require table re-cr

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.

This option tells SSMS that it can go ahead and create a Temp Table in new schema, copy data into this, then delete old table and rename the Temp Table back to original name. All fine to do as should be in transaction, however relationships will be broken and recreated so if not 100% then could do something unexpected

原文地址   https://stackoverflow.com/questions/6810425/sql-server-saving-changes-is-not-permitted-error-prevent-saving-changes-that

 Microsoft's CAVEAT    https://support.microsoft.com/en-us/help/956176/error-message-when-you-try-to-save-a-table-in-sql-server-saving-changes-is-not-permitted