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 vote388 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote342 views1 answer
Oracle turn off constraint
SQL
1 vote330 views1 answer
How to get mysql db size
SQL
0 vote341 views1 answer
Mysql check if lowercase
SQL
0 vote337 views1 answer
Oracle current timestamp
SQL
0 vote360 views1 answer
Add week ending date sql server
SQL
1 vote372 views1 answer
Alter database datafile maxsize 32g
SQL
8 votes287 views8 answers
Second highest salary in mysql
SQL
4 votes392 views4 answers
Check constraint in ms sql
SQL
1 vote311 views1 answer
Mysql collation
SQL