Saving Table Changes is not permitted in SQL Server Management Studio

I am trying to save changes in a table via SQL Management Studio.


But unfortunately, I got the following error:

The changes 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


Current SQL Management Studio settings prevent saving changes.

To enable saving changes follow the mentioned steps below:

  • Tools Menu > Options > Designers > Table and Database Designer > uncheck Prevent saving changes the require table re-creation

Table and Database Designer

You could now be able to save your changes.

Enjoy 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s