有没有办法生成级联删除语句？

Question

假设我希望删除表 AI 中的一行，但其他表中有多个外键约束。有没有办法自动生成删除命令？ 我认为应该存在一种工具，可以递归地查看外键，然后生成删除语句来处理所有外键，但我找不到。

我在 MSSql server2008 上

Answer 1

设置外键关系时，您可以添加一个ON DELETE CASCADE。

MSDN 级联引用完整性约束

ON DELETE CASCADE

Specifies that if an attempt is made to delete a row with a key referenced by foreign 
keys in existing rows in other tables, all rows containing those foreign keys are also 
deleted. If cascading referential actions have also been defined on the target tables, 
the specified cascading actions are also taken for the rows deleted from those tables.

SO甚至有一个解决方案，您不将其添加到表中：

在 SQL 中Server 2005，我可以在不设置表属性的情况下进行级联删除吗？