sqlserver 联级删除，联级更新

联级删除，需要一个是主表一个是外键表，删除主键表数据时，外键表数据也会删除。关键字：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