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 vote137 views3 answers
How to verify sequence result in oracle SQL
SQL
1 vote143 views1 answer
T-SQL Alter the column data type
SQL
2 votes211 views2 answers
How to DROP a table in mysql
SQL
0 vote149 views1 answer
Bitmap join index
SQL
0 vote162 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote129 views1 answer
Compare field sql server
SQL
0 vote150 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote140 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote136 views1 answer
Max length found in mysql
SQL
3 votes151 views3 answers
Raw select laravel
SQL