Prevent saving changes that require recreating a table SQL Server 2008

When users change the table structure in SQL Server 2008 Enterprise Manager, they must first delete the original table.

You can then re-create the new table to complete the changes to the table, and the following prompts appear if you force the changes: Save changes are not allowed

。 Your changes require that the following tables be deleted and recreated. You have made changes to the label that could not be recreated or enabled the

"Prevent saving changes that require a table to be recreated" option. To remove this hint, select options from the Tools menu,

In the Options dialog box, select Designers, select Table Designer and Database Designer, and clear the Prevent saving changes that require recreating a table check box.