问题描述
我有一个包含以下列的简单表格:id、name 和 parentID
i have one simple table with following columns: id, name and parentID
我创建了 id 和 parentID 之间的关系图(在同一张桌子上)，就像简单的树一样，在同一张桌子上，但是当我尝试用户级联时删除它被我禁用了
i created relationship diagram between id and parentID (on a same table), like simple tree, on the same table, but when i tried to user cascade delete it was disabled for me
我知道如果我删除父项，它将删除他的子项
i know that it will be recursive delete if i will delete parent it will delete his children
是否有任何选项可以在没有触发器的情况下进行级联删除?
have i any options for anable cascade delete without triggers?
推荐答案
不，SQL Server 不允许递归和/或多个级联路径.
No, SQL Server does not allow recursive and/or multiple cascade paths.
可以使用存储过程逐位删除，也可以使用触发器.对不起.
You can use a stored procedure to delete bit by bit, or use a trigger. Sorry.
这篇关于sql server、级联删除和父/子表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！