/SQL/Oracle find foreign key dependencies

Oracle find foreign key dependencies

SELECT c.OWNER, a.TABLE_NAME, a.COLUMN_NAME, a.CONSTRAINT_NAME, 
       c.R_OWNER AS REF_OWNER, cpk.TABLE_NAME AS REF_TABLE, 
       cpk.CONSTRAINT_NAME AS REF_PK
FROM ALL_CONS_COLUMNS a 
JOIN ALL_CONSTRAINTS c ON a.OWNER = c.OWNER
    AND a.CONSTRAINT_NAME = c.CONSTRAINT_NAME
 JOIN ALL_CONSTRAINTS cpk ON c.R_OWNER = cpk.OWNER
    AND c.R_CONSTRAINT_NAME = cpk.CONSTRAINT_NAME
WHERE c.CONSTRAINT_TYPE = 'R' AND c.TABLE_NAME= 'table_name';

Similar codes

2 votes119 views1 answer
How to get non distinct values in sql
SQL
1 vote114 views1 answer
Mysql remove last empty newline
SQL
7 votes118 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
1 vote112 views1 answer
Where not in array sql
SQL
1 vote106 views1 answer
Minus vs intersect in sql
SQL
4 votes117 views1 answer
Refresh postgres config
SQL
1 vote122 views1 answer
Mysql decimal allow negative values?
SQL
0 vote113 views1 answer
Oracle create package specification
SQL
4 votes71 views1 answer
Sql list users and roles
SQL
0 vote114 views1 answer
Power query datetime to date
SQL