Saving changes is not permitted in MS SQL Management studio
![Figure 1. Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created](https://markimarta.com/wp-content/uploads/2016/03/mssqltbl-01-150x150.png)
When you modify columns of a table in MS SQL management studio, you got the message "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created … " (Figure 1). The reason of this is re-creating of table. It's really important for productive environment but not very for test ones.
![Figure 1. Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created](https://markimarta.com/wp-content/uploads/2016/03/mssqltbl-01.png)
Figure 1. Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created
To fix this you should change one setting in MS SQL Management studio:
Go to "Tools / Options / Designers / Table and Database Designers" and turn off value "Prevent saving changes that require table re-creation" (Figure 2).