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
Leave a Reply