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

2 votes224 views1 answer
Oracle insert or update
SQL
3 votes198 views1 answer
Select database in sql
SQL
0 vote185 views1 answer
Db format in quotation
SQL
1 vote178 views1 answer
Pv mysql import
SQL
0 vote193 views1 answer
How to check common records in 2 table
SQL
3 votes224 views1 answer
Sql online test questions and answers
SQL
15 votes179 views4 answers
Mysql where value is null
SQL
2 votes199 views2 answers
Postgresql get table names
SQL
0 vote210 views1 answer
Mysql sum with group by
SQL
13 votes187 views2 answers
Get tables in database sql
SQL