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

0 vote214 views1 answer
Access refused mysql xampp server
SQL
0 vote236 views1 answer
Mysql c commands
SQL
3 votes235 views1 answer
Unsigned int in mysql
SQL
2 votes214 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote259 views1 answer
Sql date with year
SQL
11 votes256 views6 answers
Mysql else if
SQL
2 votes225 views1 answer
Mysql find tables with name
SQL
2 votes227 views1 answer
Possgress drop if exists table
SQL
10 votes225 views1 answer
Oracle all_dependencies
SQL
0 vote235 views1 answer
Sql find record cannot cast date
SQL