SQL> desc dict 名称 是否为空? 类型 ----------------------------------------- -------- ----------- TABLE_NAME VARCHAR2(30 COMMENTS VARCHAR2(40SQL> select * from dict where instr(comments,'constr')>0;TABLE_NAME ------------------------------ COMMENTS --------------------------------------------------------------- ALL_CONS_COLUMNS Information about accessible columns in constraint definitionsDBA_CONS_COLUMNS Information about accessible columns in constraint definitionsUSER_CONS_COLUMNS Information about accessible columns in constraint definitions 先找到外鍵: SELECT a.r_constraint_name,b.column_name from user_constraints a, user_cons_columns b where a.table_name = 'your_table' and a.constraint_type='R' and a.constraint_name=b.constraint_name 然后: alter table ... drop constraint foreignKeyName
要删除b的外键应用
该如何写sql
名称 是否为空? 类型
----------------------------------------- -------- -----------
TABLE_NAME VARCHAR2(30
COMMENTS VARCHAR2(40SQL> select * from dict where instr(comments,'constr')>0;TABLE_NAME
------------------------------
COMMENTS
---------------------------------------------------------------
ALL_CONS_COLUMNS
Information about accessible columns in constraint definitionsDBA_CONS_COLUMNS
Information about accessible columns in constraint definitionsUSER_CONS_COLUMNS
Information about accessible columns in constraint definitions
先找到外鍵:
SELECT a.r_constraint_name,b.column_name
from user_constraints a, user_cons_columns b
where a.table_name = 'your_table' and a.constraint_type='R'
and a.constraint_name=b.constraint_name
然后:
alter table ... drop constraint foreignKeyName