删除MS ACCESS 2007中的多个表 [英] Delete Multiple Tables in MS ACCESS 2007

问题描述

在主表中有主键和其他两个表有参考键。删除MS ACCESS 2007中一次性特定ID的数据



问候

Rajesh V

Hi,

In Main Table having Primary Key and other two table having reference key. Delete the data in one shot particular id in MS ACCESS 2007

Regards
Rajesh V

推荐答案

您需要使用级联规则设置外键约束。

这样，当您删除父记录时，所有子记录都会被删除。

类似的事情你可以在单个存储过程中手动完成

首先删除所有子记录，然后删除父记录。

You needs to set foreign Key Constraint with cascade rule.
So that, when you delete parent record all child records gets deleted.
Similar thing you can done manually in a single stored proc as
First delete all child records then delete parent record.

这篇关于删除MS ACCESS 2007中的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！