且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在SQL Server 2005中无法删除约束,“无法删除约束。查看先前的错误”

更新时间:2023-02-04 13:22:04

找到了一种对此进行排序的方法,尽管我不明白为什么这样做是必要的。

Found a way to sort this, although I don't understand why it was necessary.

能够通过首先禁用它来删除约束:

Have been able to drop the constraint by disabling it first:

ALTER MyTable NOCHECK CONSTRAINT FK_MyTable_AnotherTable

然后完成删除操作

仍然欢迎任何对此必要原因的评论

Would still welcome any comments on the reason why this is necessary