Oracle foreign key reference table

Foreign key on table oracle

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';

Oracle foreign key reference table

SELECT cons.OWNER 			AS CHILD_OWNER,
       cons.TABLE_NAME 		AS CHILD_TABLE,
       cons.CONSTRAINT_NAME AS CONSTAINT_NAME,
       cons.CONSTRAINT_TYPE AS CONSTRAINT_TYPE,
       col.OWNER 			AS PARENT_OWNER,
       col.TABLE_NAME 		AS PARENT_TABLE,
       col.COLUMN_NAME 		AS COLUMN_NAME
FROM DBA_CONS_COLUMNS col, DBA_CONSTRAINTS cons
WHERE cons.R_OWNER = col.OWNER
  AND cons.R_CONSTRAINT_NAME = col.CONSTRAINT_NAME
  AND cons.TABLE_NAME = 'table_name';

Source: dba-oracle.com

Similar codes

17 votes304 views3 answers
Cast in sql server
SQL
0 vote321 views1 answer
Print boolean in plsql
SQL
7 votes322 views3 answers
SQL create a new table
SQL
0 vote308 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote297 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote311 views1 answer
Inserting data into different tables at once in oracle sql
SQL
13 votes337 views4 answers
What is sql
SQL
10 votes306 views2 answers
Show tables in schema oracle
SQL
2 votes294 views1 answer
Mysql cannot delete or update a parent row
SQL
2 votes305 views1 answer
Add new column not null sql server
SQL