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