SQL级联删除

alter table zhuzhai add constraint FK_zhuzhai_tiaozheng foreign key (zhuzhaiId)
references zhuzhai(zhuzhaiId) on delete cascade on update cascade


alter table 表名 add constraint 外键名 foreign key(字段名) references 主表名(字段名) on delete cascade

 

alter table [丛表名] add constraint [设置外键名称] foreign key ([设置外键列]) references [具有主键的表名] ([具有主键的列]) on delete cascade