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 vote242 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote271 views1 answer
Sql developer format sql
SQL
6 votes197 views1 answer
What is where clause in sql
SQL
1 vote200 views1 answer
Search for replace in mysql
SQL
0 vote225 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote200 views1 answer
Windows aggregate functions in postgresql
SQL
1 vote192 views1 answer
Mysql count words
SQL
0 vote227 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote195 views1 answer
Oracle sql winter time change
SQL
0 vote200 views1 answer
Reona
SQL