表にかけられている制約を確認するSQL - ablogSQL select constraint_name, constraint_type from all_constraints where owner = upper('&owner') and table_name = upper('&table'); 実行例 SQL> select constraint_name, constraint_type from all_constraints where owner = upper('&owner') 2 3 4 and table_name = upper('&table'); Enter value for owner: scott old 3: where owner = upper('&owner') new 3: where owner = upper('scott') Enter value for table: emp ol
