Home > Database > Mysql Tutorial > Access和SQL server开启表间关系,并实现更新或删除母表数据自动

Access和SQL server开启表间关系,并实现更新或删除母表数据自动

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 15:38:27
Original
1320 people have browsed it

1.Access 开启 表间 关系 ,并 实现 删除 母表 数据 自动 删除 子表 数据 : 在Tables等界面 - 右键 - Relationships... - 弹出Relationships窗口 - 选择需要关联的表 - 双击Relationships窗口空白位置 - 弹出 Edit Relationships 窗口 - 就可以看到Enforce Re

1.Access开启表间关系,并实现删除母表数据自动删除子表数据:

在Tables等界面 - > 右键 - > Relationships... -> 弹出Relationships窗口 -> 选择需要关联的表 -> 双击Relationships窗口空白位置 -> 弹出 Edit Relationships 窗口 -> 就可以看到Enforce Referential Integrity选项 -> 选中就可以继续选择 Cascade...了.

2.SQL Server开启表间关系,并实现删除母表数据自动删除子表数据:

创建外键 -> 在外键弹出窗口 Foreign Key Relationships窗口 -> 可以看到 INSERT AND UPDATE Secification -> 下边就是相应设置.(可用SQL语句设置)

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Access error using alias
From 1970-01-01 08:00:00
0
0
0
Single module access
From 1970-01-01 08:00:00
0
0
0
About Mac MAMP PRO deploy thinkphp5.1 access 404
From 1970-01-01 08:00:00
0
0
0
My access page reports 403
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template