SQL Server 2008 error when modifying a database table "prevent saving changes that require the table to be recreated"

When a user changes the table structure in SQL Server 2008 Enterprise Manager, you must delete the original table and recreate the new table to complete the table changes, and if you forcibly change the following prompt: Save changes are not allowed. Your changes require that the following tables be deleted and recreated. You have made changes to the label that cannot be recreated or enabled the "Prevent saving changes that require table re-creation" option. If you want to remove this hint, choose Options from the Tools menu, select Designers in the Options dialog box, select Table Designer and Database Designer, and clear the block save changes required to recreate table check box.

Reprint Please specify source: http://www.cnblogs.com/0351jiazhuang/p/4534695.html

SQL Server 2008 error when modifying a database table "prevent saving changes that require the table to be recreated"