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 vote207 views1 answer
Sql pivot table
SQL
0 vote188 views1 answer
Add column not null with default value postgres
SQL
0 vote200 views1 answer
Mysql c commands
SQL
0 vote194 views1 answer
Mysql count by month
SQL
0 vote208 views1 answer
Check database restore status sql script
SQL
0 vote202 views1 answer
Sql on-premises
SQL
0 vote187 views1 answer
Sql server pivot rows to columns
SQL
0 vote191 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
8 votes229 views2 answers
Oracle undo usage
SQL
0 vote186 views2 answers
How to find max and min salary in sql
SQL