IMG-LOGO
Home Blog TSQL

Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created

andy - 25 Jan, 2014 2917 Views 0 Comment

When altering a table in SQL Server management studio, sometimes you get the following error message:

"Saving changes is not permitted. The changes you have made require the following table 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. ".

saving changes is not permitted

To solve this issue, it is actually pretty easy, just go to the Tools Menu > Option.

In the designer section, there is submenu called Table and Database Designers, click this option. A table option will be displayed on the right hand side. Look for the option "Prevent saving changes that require table re-creation".

Share:
Facebook Twitter

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

TSQL
26 Feb, 2021
If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

TSQL
20 Feb, 2021
To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...