sql server、级联删除和父/子表 [英] sql server, cascade delete and parent/child table

问题描述

我有一个包含以下列的简单表格: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、级联删除和父/子表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！