/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

3 votes179 views2 answers
Mysql config user password
SQL
0 vote222 views2 answers
Insert data into multiple tables mysql
SQL
0 vote177 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote187 views1 answer
Java sql insert return id
SQL
-1 vote166 views1 answer
Sql select data from one database and insert into a different database
SQL
16 votes180 views2 answers
Sql exists
SQL
10 votes181 views6 answers
Mysql delete duplicates
SQL
2 votes193 views1 answer
Oracle apex who is connected
SQL
2 votes171 views2 answers
How to check database username and password in postgresql
SQL
0 vote185 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL