Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated...

Hi Friends,

If you see this error while you trying to save your table changes in sql server design mode,

 Follow the below steps to solve this issue.

Go to menu "Tools--> Options"
Select "Designers"
Uncheck the check box "Prevent saving changes that require table re-creation".

 

Thank you