Oracle list constraints

SELECT *
FROM ALL_CONSTRAINTS c,
     ALL_CONS_COLUMNS cols
WHERE c.CONSTRAINT_TYPE = 'P'
  AND c.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME
  AND c.OWNER = COLS.OWNER
  AND c.OWNER = 'schema_name'
  AND cols.TABLE_NAME = 'table_name'
ORDER BY cols.TABLE_NAME, COLS.POSITION;

Similar codes

8 votes182 views1 answer
Oracle add datafile to tablespace
SQL
31 votes166 views3 answers
Sql count
SQL
0 vote171 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote201 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote186 views1 answer
Oracle chain step succeeded
SQL
1 vote172 views1 answer
Convert epoch to date in sql server
SQL
0 vote166 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote172 views3 answers
Above average salary in sql
SQL
0 vote177 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote177 views2 answers
Pad zero sql server
SQL