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.
Here is the solution…
uncheck the “prevent saving changes that require table re-creation” checkbox as follow :