How to fix "Prevent saving changes that require the table to be re-created" when you try to save a table in SQL Server<br><br>Cause<br>This warning that prevents the actions from completing is caused by the Prevent saving changes that require table re-creation option being triggered in SQL Server. This option lets SQL Server to prevent structure changes when a table needs to be recreated and is intended as a security feature. However, this also prevents planned changes from completing.<br><br>This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table: <br>- You change the Allow Nulls setting for a column. <br>- You reorder columns in the table. <br>- You change the column data type. <br>- You add a new column.
Originally collected by
fetching...
(
less)
