当前位置：Gxlcms >
数据库问题 >
修改SQL Server 表时提示：Saving changes is not permissted .The changes you have made require the following tables to be dropped and re-created ......
修改SQL Server 表时提示：Saving changes is not permissted .The changes you have made require the following tables to be dropped and re-created ......
时间：2021-07-01 10:21:17
帮助过：3人阅读
修改数据库表的时候，无法选择保存，提示：saving changes is not permitted , 如下图1，如果选择cancle，就会撤销保存，如果选择Save Text File，就会保存一个TXT 文件，不过不是sql 脚本，个人觉得没用。
解决方法：不要捉急，这是因为你设置了保存修改时重建表（一般是默认的）
1.回到SQL server首页。
2. 选择Tools-->Options-->Designers-->Table and Database Designers ,去掉Prevent saving changes that require table re-creation .
修改SQL Server 表时提示：Saving changes is not permissted .The changes you have made require the following tables to be dropped and re-created ......
标签：
