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

1 vote297 views1 answer
Oracle create program if no exists
SQL
3 votes303 views1 answer
Oracle get trigger ddl
SQL
0 vote320 views1 answer
Postgresql check total storage
SQL
0 vote289 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote284 views1 answer
How to delete record sql delphi
SQL
5 votes326 views4 answers
Start postgres server
SQL
1 vote304 views2 answers
Oracle list partitioned tables
SQL
0 vote328 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote305 views2 answers
How to use aggregate functions in sql
SQL
1 vote316 views1 answer
Deleting database in sql
SQL