Saving Table Changes is not permitted in SQL Server Management Studio

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

CreateTable

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

3

Cause:
Current SQL Management Studio settings prevent saving changes.

Solution:
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 🙂

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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