I was modifying an existing table using SQL Server Management Studio 2008 R2, 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:
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 2008
- Go to Tools menu then Options
- On Options Tree view, Click Designers
- Unchecked Prevent saving changes that require the table re-creation option
Source: https://www.nilebits.com/blog/2020/03/prevent-saving-changes-that-require-table-re-creation-sql-server/
