Prevent Saving Changes That Require Table Re-creation SQL Server

I was modifying an existing table using SQL Server Management Studio, but I got this error message on saving:

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 error occurs when the Prevent saving changes that require the table re-creation option is enabled. Also it occurs if you made one of these changes to the table:

• Adding a new column
• Change column Data type
• Allow Nulls for a column
• Change the order of a the table columns

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

• Open SQL Server Management Studio
• Go to Tools menu then Options
• On Options Tree view, Click Designers
• Unchecked Prevent saving changes that require the table re-creation option