MS SQL

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created.

Here when we are try to alter the table design may be we will get the below error. how we will fix?

How we will fix?

Go To the menu in SSSM Tools >> Options >> Designers and uncheck “Prevent Saving changes that require table re-creation”

Thanks for visiting my blog..!!

Leave a Reply

Prabhakaran Jayaraman