Saving Changes is not permitted The changes you have made require the following tables to be dropped and recreated – SQL Server 2008

Today, while changing the column definition i came across the following message

“Saving Changes is not premitted. The changes you have made require the following tables to be dropped and recreated……..”

I created a table without primary key and then later tried to add the primary key using the ALTER TABLE command but got the below message.

The solution to the above message is:

1. In the SQL Server Management Studio, go to Tools –> Options. you will get the options window as show below.

2.  Uncheck the 6th option under Table options i.e. Prevent saving changes that require table re-creation. See the image below

 

3. Now you should be able to modify the table definition.

Happy Learning !!!