Prevent Saving Changes That Require Table Re-Creation

A few days ago when I installed the SQL Server, I faced this issue after a successful reinstall. In this issue, you will be able to create a table successfully and everything will be okay until you are in need to make some changes to the structure of the table.

Prevent Saving Changes That Require Table Re-Creation

When you will try to change the table design it will not let you change it and give you the following error.

Prevent Saving Changes that requires

This happens due to an option in SSMS (SQL Server Management Studio) provided by Microsoft for security purposes. Making changes to table design a critical decision and no one should do this by mistake. This option stops everyone from making changes to a stable structure.

In order to disable this option you need to follow the steps below.

Step 1

First Log in to the SSMS (SQL Server Management Studio).

Step 2

Next, you need to click on Tools in the Menu bar and then press Options. If the Menu bar is not shown, press the Alt key on the keyboard.

Step 3

You will see the following window, You need to click on Designers option.

Step 4

Uncheck the option “Prevent Saving Changes That Require Table Re-Creation“. Once unchecked, press OK.

I hope this article was helpful. After following the steps above, you would need to restart the SSMS and you will be able to make changes to table design and save them.

See you next time guys.

Good Luck!

In case you are interested, read out previous article regarding Arrays in C#.