how to find constraints on a table in oracle

Solutions on MaxInterview for how to find constraints on a table in oracle by the best coders in the world

showing results for - "how to find constraints on a table in oracle"
Michelle
20 Oct 2016
1SELECT cons.OWNER 			AS CHILD_OWNER,
2       cons.TABLE_NAME 		AS CHILD_TABLE,
3       cons.CONSTRAINT_NAME AS CONSTAINT_NAME,
4       cons.CONSTRAINT_TYPE AS CONSTRAINT_TYPE,
5       col.OWNER 			AS PARENT_OWNER,
6       col.TABLE_NAME 		AS PARENT_TABLE,
7       col.COLUMN_NAME 		AS COLUMN_NAME
8FROM DBA_CONS_COLUMNS col, DBA_CONSTRAINTS cons
9WHERE cons.R_OWNER = col.OWNER
10  AND cons.R_CONSTRAINT_NAME = col.CONSTRAINT_NAME
11  AND cons.TABLE_NAME = 'table_name';
queries leading to this page
oracle alter table add foreign keyadd foreign key in oracleforeign key oracle exampleoracle foreign keycreate foreign key in oracleforeign key oracle sqlforeign key sql oraclehow to add foreign key in oracleoracle sql foreign keyforeign key oracleoracle foreign keyhow to add foreign key oracleforeign key oracle meaningadd foreign key constraint oraclealter table to add foreign key constraint in oracleoracle foreign key constraintcreate table in oracle with foreign keyhow to view constraints on a table in oracleoracle foreign key columnsdefine foreign key in oracleoracle foreign key constraint in create tabledefine foreign key in oracle when creating tableoracle find constraints referencing a tableadd foreign key while creating table oraclehow to find constraints on a table in oraclehow to check the constraints on a table in oracleforeign key in oraclehow to create foreign key in sql oracleoracle add foreign keyhow to view all constraints on a table in oracleoracle sql command to set constraints in tableconstraints in oraclehow to check constraints on a table in oracle sqloracle foreign key syntaxcreate table with foreign key in oraclehow to check all constraints on a table in oracleexplain oracle foreign key constraintfind constraints in oraclehow to create a foreign key in oracle sqlfind all constraints on a table oracleoracle foreign key reference tableforeign key sql oracle syntaxcreate table with foreign key oraclehow to create foreign key in oracle for existing tableoracle db create table with foreign keyhow to find constraints oracleforeign key in oracle databaseforeign key in oracle sqlhow to create table with foreign key oraclecreate table oracle foreign keyoracle constraints on tablehow to find constraints on a table in oracle