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

2 votes115 views1 answer
Cast string to datetime mysql
SQL
1 vote128 views3 answers
Update from select sqlite
SQL
1 vote121 views1 answer
Nullif postgresql
SQL
1 vote110 views2 answers
Mysql order by date asc null last
SQL
0 vote124 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote114 views1 answer
Mysql undo delete
SQL
1 vote135 views1 answer
Mysql show long running queries
SQL
2 votes110 views1 answer
Get first 2 letter in sql
SQL
1 vote114 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote111 views1 answer
Events not working db
SQL