我想用join连接同时删除这两个表怎么做？ [英] I want to delete both the tables at same time using join how to do it?

问题描述

create table DeleteTest1
(
	EmpId int,
	Name nVarchar
	primary key (EmpId)
)



create table DeleteTest2
(
	EmpId int ,
	Age int,
	Salary Float
	constraint FK_TestDeleteEmpID Foreign key(EmpId)
	References DeleteTest1(EmpId)
)


insert into DeleteTest1  values (11614,'Vii')

insert into DeleteTest2 values (11614,21,12222)


delete dt2 from   DeleteTest1  dt1 inner join DeleteTest2 dt2 on dt2.EmpId=dt1.EmpId

我尝试过：



我试过删除DeleteTest2表首先因为它有外键引用，但我也希望通过连接两个表来删除DeleteTest1表。如何通过单个连接查询删除这两个表条目

What I have tried:

I tried deleting DeleteTest2 table first because it has foreign key reference, but i also want to delete DeleteTest1 table by joining both the tables.How can i delete these both table entries by a single join query

推荐答案

使用：

1. SQL Server：具有级联删除的外键 [ ^ ]

2. 级联参照完整性约束 [ ^ ]

Use:
1. SQL Server: Foreign Keys with cascade delete[^]
2. Cascading Referential Integrity Constraints[^]

这篇关于我想用join连接同时删除这两个表怎么做？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！