SQL Server - Saving changes is not permitted error message in SQL Server Management Studio

preview_player
Показать описание
When you try to save a table after making changes to the table using Designer in SQL Server management Studio, you may receive the following error message:

Saving changes is not permitted. The changes that 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 problem occurs when you make one or more of the following changes to the table:

You change the Allow Nulls setting for a column.
You reorder columns in the table.
You change the column data type.
You add a new column.
You change the filegroup of a table or its text/image data.

Cause
This problem occurs because the Prevent saving changes that require the table re-creation  option is enabled by default in SQL Server Management Studio.

When you change a table so that you alter the metadata structure of the table, and then you save the table, the table must be re-created based on these changes. This may result in the loss of metadata and in a direct loss of data during the re-creation of the table. If you enable the Prevent saving changes that require the table re-creation option in the Designer section of the SQL Server Management Studio (SSMS) Options window, you receive the error message that is mentioned in the 'Symptoms' section.
Рекомендации по теме
join shbcf.ru