oracle list constraints
Solutions on MaxInterview for oracle list constraints by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle list constraints"
Chiara
07 Jun 2017
1SELECT *
2FROM ALL_CONSTRAINTS c,
3 ALL_CONS_COLUMNS cols
4WHERE c.CONSTRAINT_TYPE = 'P'
5 AND c.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME
6 AND c.OWNER = COLS.OWNER
7 AND c.OWNER = 'schema_name'
8 AND cols.TABLE_NAME = 'table_name'
9ORDER BY cols.TABLE_NAME, COLS.POSITION;similar questions
oracle list columns in schemaoracle list typesoracle list subpartitionsoracle list usersoracle list viewsoracle list programoracle list columns schemaoracle tablespace tables listoracle list functionshow to get list of synonyms in oraclecolumn names in oracle sqltablespace oracleoracle find constraints referencing a tablehow to find constraints on a table in oracleoracle table constraintsoracle list tablespacesalter table add check constraint oracleoracle list primary keyoracle list tablesoracle list columnsoracle all tableslist foreign key oracleoracle list rolesoracle list service namesoracle unique constraintsql show custom constraintsoracle column names of a tableoracle list rules your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful