将导致循环或多重级联路径create table tab1(ID int primary key)
create table tab2(ID1 int references tab1(id) on delete cascade,ID2 int references tab1(id) ON DELETE NO ACTION)
create table tab2(ID1 int references tab1(id) on delete cascade,ID2 int references tab1(id) ON DELETE NO ACTION)
你可怜把主表的主键设为表一列和表二列,试试看,也许会通的