如何在MS SQL Server中的自引用表上级联删除？ [英] How to cascade delete on self referencing table in MS SQL Server?

问题描述

hi
如何在ms sql server中的自引用表上级联删除？即时通讯使用asp.net C＃，我有表类别#id名称parent_id我希望每次用户删除父类别，子类别也删除，sql server不要让我更改更新或插入规则为自我退化表，是否我必须使用触发器或CTE？

hi how can i cascade delete on self referencing table in ms sql server? im using asp.net C# , i have table Category #id name parent_id and i want every time user delete a parent category , childs categories also delete, sql server dont let me to change the update or insert rule for self refrencing table , whether i have to use trigger or CTE?

推荐答案

删除子类别上的现有FK约束并重新创建FK但添加ON DELETE CASCADE。

Drop your existing FK constraint on Child Categories and recreate the FK but add a ON DELETE CASCADE.

这篇关于如何在MS SQL Server中的自引用表上级联删除？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！