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

26 votes114 views2 answers
Mysql workbench download
SQL
0 vote115 views1 answer
How to use lower case in mysql
SQL
3 votes114 views1 answer
Pl sql escape &
SQL
0 vote117 views1 answer
Mysql update from select on same table
SQL
0 vote111 views1 answer
Postgres truncate with cascade
SQL
1 vote108 views1 answer
Database Queries
SQL
1 vote183 views1 answer
Oracle create program if not exists
SQL
0 vote110 views2 answers
How to find max and min salary in sql
SQL
0 vote103 views1 answer
Take sql dump in to file
SQL
0 vote108 views1 answer
Mssql now diff 90 day
SQL