READER_LEND_RULE : FK_READER_L_R_L_READER_T
READER_LEND_RULE_PLACE: FK_READER_L_R_P_READER_L
READER: FK_READER_RT_R_READER_T
READER_FINANCE: FK_READER_F_C_R_READER
READER_LEND_RECORD: FK_READER_L_L_R_READER
READER_LEND_RULE: FK_READER_L_R_L_READER_T有这几个外键关联现在我想级联删除
怎么alter他们的cascade属性啊
求语句啊
我只记得是用alter吧
READER_LEND_RULE_PLACE: FK_READER_L_R_P_READER_L
READER: FK_READER_RT_R_READER_T
READER_FINANCE: FK_READER_F_C_R_READER
READER_LEND_RECORD: FK_READER_L_L_R_READER
READER_LEND_RULE: FK_READER_L_R_L_READER_T有这几个外键关联现在我想级联删除
怎么alter他们的cascade属性啊
求语句啊
我只记得是用alter吧
alter table READER
add constraint FK_READER_RT_R_READER_T foreign key (READER_TYPE_ID)
references READER_TYPE (ID);这个是建外键的语句
研究出来了
alter table READER
add constraint FK_READER_R_C_SCHOOL_D foreign key (SCHOOL_DEPT_ID)
references SCHOOL_DEPT (ID) on delete cascade;谁来回答下啊 送分