代入表格名後，可以找到其他有引用到本表格欄位的外鍵。
SELECT table_name, constraint_name, r_constraint_name, status
FROM user_constraints
WHERE constraint_type = 'R'
AND r_constraint_name in
(
SELECT constraint_name from user_constraints
WHERE constraint_type in ('P', 'U')
AND UPPER(table_name) = UPPER('table_name')
)
ORDER BY table_name, constraint_name;
代入表格名後，可以找到本表格找用了哪些表格欄位作外鍵。
SELECT table_name, constraint_name, r_constraint_name, status
FROM user_constraints
WHERE constraint_type = 'R'
AND UPPER(table_name) = UPPER('table_name')
ORDER BY table_name;
文章標籤
全站熱搜
