SQL server does not allow you to save changes to a workaround

2. When you design a SQL Server database, there are times when you are not allowed to save changes. This is a protection mechanism for SQL Server because it enables blocking save changes that require the table to be recreated.
   

4. 
   

6. 
   

8. 
   

10. 1 Error hints appear when you modify a table's structure, data type

    650) this.width=650; "class=" Exp-image-default "alt=" SQL Server does not allow the solution to save changes "src=" https://imgsa.baidu.com/exp/w=500 /sign=0897c442d52a60595210e11a1835342d/4a36acaf2edda3cc254190ab03e93901203f9297.jpg "style=" border:0px; "/>

12. 2

    Click "Tools" → "Options" above

    650) this.width=650; "class=" Exp-image-default "alt=" SQL Server does not allow the solution to save changes "src=" https://imgsa.baidu.com/exp/w=500 /sign=06866b7da5efce1bea2bc8ca9f50f3e8/a9d3fd1f4134970aa62738a497cad1c8a6865de0.jpg "style=" border:0px; "/>

14. 3

    In the Options dialog box, click on "designer" → "Table Designer and Database Designer"

    650) this.width=650; "class=" Exp-image-default "alt=" SQL Server does not allow the solution to save changes "src=" https://imgsa.baidu.com/exp/w=500 /sign=bc6f07f7530fd9f9a0175569152cd42b/caef76094b36acaf794abe777ed98d1000e99c96.jpg "style=" border:0px; "/>

16. 4

    Remove the check in front of prevent saving changes that require the table to be recreated, and then determine

    
    

    OK, let's try again, it should be possible to modify the structure of the table properly \ (^o^)/

    650) this.width=650; "class=" Exp-image-default "alt=" SQL Server does not allow the solution to save changes "src=" https://imgsa.baidu.com/exp/w=500 /sign=1c786f304510b912bfc1f6fef3fcfcb5/d01373f082025aaf75665640f9edab64024f1ae0.jpg "style=" border:0px; "/>

18. 
    

This article is from the "http://82711020.blog.51cto.com/12993840/1983915" blog, please be sure to keep this source.

SQL server does not allow you to save changes to a workaround