/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

24 votes145 views6 answers
Alter table name sql
SQL
0 vote144 views1 answer
Can you write relational algebra into sql queries
SQL
33 votes135 views6 answers
Sql delete
SQL
13 votes157 views2 answers
Oracle inner join
SQL
0 vote142 views1 answer
Laravel migration sql dump
SQL
0 vote140 views1 answer
Mysql local password denied
SQL
0 vote133 views1 answer
SQL Server rename foreign key constraint
SQL
8 votes146 views2 answers
Change name of colum in sql table
SQL
0 vote131 views1 answer
Sqlite select split string
SQL
1 vote222 views1 answer
Oracle current sequence value
SQL