MSSQL的“Saving changes is not permitted...”处理方法

最新推荐文章于 2025-07-03 15:45:30 发布

原创最新推荐文章于 2025-07-03 15:45:30 发布 · 761 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MSSQL

MSSQL 专栏收录该内容

1 篇文章

订阅专栏

本文探讨了在使用特定软件时遇到的错误提示：'Saving changes is not permitted. The change you have made requires the following table to be dropped and recreated.'。通过检查选项设置，特别是禁用‘PreventSaving changesthat require table re-creation’的功能，可以解决此类问题。文章提供了详细的步骤和解释，帮助用户避免常见错误并提高工作效率。

"Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created."

Tools >> Options >> Designers and uncheck “Prevent Saving changes that require table re-creation”