/SQL/Oracle find constraints referencing a table

Oracle find constraints referencing a 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

0 vote161 views1 answer
Sql server synonym
SQL
0 vote157 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote264 views1 answer
Mysql delete entire row on condition
SQL
0 vote166 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote173 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote144 views2 answers
Mysql on update current_timestamp
SQL
0 vote188 views1 answer
Ms sql print more than 1 variable
SQL
1 vote218 views4 answers
Alter schema sql
SQL
49 votes247 views6 answers
Mysql add column to table
SQL
0 vote149 views2 answers
Zsh: command not found: mysq
SQL