/SQL/How to find constraints on a table in oracle

How to find constraints on a table in oracle

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

1 vote277 views1 answer
Woocommerce mysql price table
SQL
0 vote269 views1 answer
Postgresql create user roles
SQL
4 votes269 views2 answers
How to insert ip address in mysql using php
SQL
104 votes447 views2 answers
Like in mysql
SQL
0 vote252 views1 answer
How to see the query of a view in mysql
SQL
0 vote325 views1 answer
Mysql streaming example
SQL
0 vote273 views1 answer
MySQL import data from large CSV file
SQL
2 votes257 views1 answer
Mysql select random id from table
SQL
0 vote269 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote286 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL