In mssql server manager, when trying to update tables design, you get this message :
Saving changes is not permitted. The changes you have made require the following tables to be dropper and re-created.
![SqlPreventSaveDesignerError](http://tech.cybernet.lu/wp-content/uploads/2012/06/SqlPreventSaveDesignerError-300x241.png)
Here is the solution…
uncheck the “prevent saving changes that require table re-creation” checkbox as follow :
![SqlPreventSaveDesigner](http://tech.cybernet.lu/wp-content/uploads/2012/06/SqlPreventSaveDesigner-300x175.png)