联级删除,需要一个是主表一个是外键表,删除主键表数据时,外键表数据也会删除。关键字:on delete cascade
-- 联级删除
create table Catagry(
Id int primary key Identity,
CatagryName nchar(50)
)
create table Product(
Id int primary key Identity,
ProductName nvarchar(50),
CatagryId int foreign key references catagry(Id) on delete cascade --联级删除
)
insert Catagry values('手机'),('电脑')
insert Product values('小米手机',1),('华为手机',1)
insert Product values('小米电脑',2),('华为电脑',2)
select * from Catagry
select * from Product
delete from Catagry where Id