现在有两个表,主表 QUERY_CONFIG,字表 QUERY_TERM_INFO
1. 为字表建立外键约束
alter table QUERY_TERM_INFO add constraint FK_QUERYTERMINFO_0 foreign key (QUERY_ID)
references QUERY_CONFIG (QUERY_ID);
2. 删除外键约束
alter table QUERY_TERM_INFO drop constraint FK_QUERYTERMINFO_0;
原文链接:https://www.f2er.com/oracle/209269.html