/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 vote354 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote373 views1 answer
Sql query to force the database to be drop
SQL
1 vote420 views2 answers
Coderbyte sql solutions
SQL
15 votes338 views4 answers
Pl sql
SQL
0 vote330 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote347 views1 answer
Synapse sql table set pk
SQL
0 vote347 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote305 views1 answer
Select all domains of database firbird
SQL
0 vote543 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote328 views1 answer
Oracle list chain steps
SQL