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
SQL级联删除
最新推荐文章于 2016-11-20 16:55:00 发布