Access中如何用SQL语句创建表的级联删除及更新关系?
Access中如何用SQL语句创建表的级联删除及更新关系?用on delete cascade和on update cascade,提示constrain子句语法错误,请大家帮帮忙
回复 2楼 longerth
SQL语句为:"alter table midBaseLineTable add constraint baseLineTablemidBaseLineTable foreign key (lineId) references baseLineTable(id) on delete cascade on update cascade";执行时会提示constrain子句语法错误
我想要的是用SQL语句修改表关系的级联删除及更新,而不是手动修改