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

6 votes115 views2 answers
Postgresql database url
SQL
0 vote103 views1 answer
Find and replace query in wordpress\
SQL
28 votes104 views4 answers
Delete database mysql
SQL
0 vote102 views1 answer
Mariadb number format
SQL
5 votes109 views2 answers
Oracle find all tables with column name
SQL
8 votes95 views1 answer
Oracle add month
SQL
0 vote107 views1 answer
Mysql to get column name in database
SQL
4 votes113 views2 answers
Delete all table oracle
SQL
3 votes108 views1 answer
Sql case update
SQL
0 vote123 views2 answers
How to see table associated with a schema in sql
SQL