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 vote133 views1 answer
Check duplicate values plsql
SQL
9 votes162 views3 answers
Sequence postgresql
SQL
7 votes142 views3 answers
Select latest entry in sql table
SQL
0 vote148 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote161 views1 answer
MySQL import data from large CSV file
SQL
0 vote154 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote132 views1 answer
Sql server split string and insert into table select
SQL
0 vote139 views1 answer
Change date format in oracle query
SQL
0 vote158 views1 answer
Postgresql show owner of database
SQL
0 vote136 views1 answer
Oracle exchange subpartition
SQL