SQL Admin - 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

Saving Changes Is Not Permitted. The Changes That You Have Made Require The Following Tables To Be Dropped And Re-Created

Cause

If the Prevent saving changes that require the table re-creation option is enabled, one or more of the following changes are made to the table in database:

        I.            Change Allow Nulls setting for a column.

      II.            Reorder columns in the table.

    III.            Change column data type.

    IV.            Add a new column.

You are altering the metadata structure of the table when you changed a table in database, 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.

Solution

To change the Prevent saving changes that require the table re-creation option, follow these steps:

        I.            In SSMS

      II.            Go to Tools menu, click Options.

    III.            Click Designers.

    IV.            Uncheck (clear) the Prevent saving changes that require the table re-creation checkbox

      V.            Click OK.