Changes cannot be saved. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created, or you have enabled the change to prevent table re-creation after saving. You are not allowed to save the changes.

Changes cannot be saved. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created, or you have enabled the change to prevent table re-creation after saving. You are not allowed to save the changes.

Changes cannot be saved. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created or enabled the "change to prevent table re-creation from being saved" feature.

SQL Server often encounters this problem when modifying database tables. The solution is as follows:

In SQL SERVER, open tool =, option =, designer =, Table Designer and Database Designer, and remove = from the check box for "blocking SAVE requirements for re-creating tables.

In SQL 2012, how does one change the option of "Preventing table creation changes "?

When you change the table structure in SQL Server 2008 Enterprise Manager, you must first Delete the original table and then create a new table to change the table. If you forcibly change the table, the following prompt appears: changes cannot be saved. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created or enabled the "change to prevent table re-creation after saving" option. To remove this prompt, select "option" from the "Tools" menu, select "Designers" in the "options" dialog box, and select "Table Designer and Database Designer ", clear the "Block save changes requiring table creation again" check box.

2012 should be similar
 
Prevents changes to the table to be recreated from being saved.

When you change the table structure in SQL Server 2008 Enterprise Manager, you must first Delete the original table and then create a new table to change the table. If you forcibly change the table, the following prompt appears: "You cannot save the changes. You must delete and recreate the following tables. You have changed the tags that cannot be re-created or enabled the "" option ". If you want to remove this prompt, open the SQL server 2008 tool -- option -- Designers -- Table Designer and Database Designer, remove the "" check, and click "OK ".