如何在sqlserver 2008r2中删除主行和明细行表 [英] how to delete master and details row table in sqlserver 2008r2

问题描述

嗨.

我想删除表中的所有行，但是我无法使用foregin key.this表是主表，并且有一些子项，因此我想删除所有这些表中的所有行，但是我不希望这样做不知道吗?

尽管我认为我必须使用级联删除语句，但是我该怎么做，级联选项在哪里?


谢谢您的关注.

Hi.

i want to delete all rows from a table , but i can''t becuase of foregin key.this table is a master table and has some childs , so i would like to delete all rows from all of those tables ,but i don''t know how?

although i think i have to use cascading delete statement but how can i do that & where is cascading option?


thank you for your attention

推荐答案

首先，您应该从依赖表中删除，然后从主表中删除.

firstly u should delete from dependent table then master table .

这篇关于如何在sqlserver 2008r2中删除主行和明细行表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！