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 vote155 views1 answer
What is SQL data store?
SQL
1 vote152 views1 answer
Create new table in SQL from old table with data
SQL
2 votes144 views1 answer
Sql create database
SQL
0 vote156 views1 answer
PSQL qith variables
SQL
42 votes223 views6 answers
Sql query duplicate rows
SQL
0 vote165 views1 answer
Postgres list all triggers
SQL
0 vote194 views1 answer
Capabilities of sql select statements
SQL
0 vote144 views1 answer
Mysql command line ubuntu
SQL
1 vote153 views1 answer
Mysql remove last empty newline
SQL
54 votes359 views6 answers
Sql rename column
SQL