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

3 votes153 views2 answers
Update Query in SQL Server
SQL
1 vote147 views1 answer
Find logged in users mysql
SQL
0 vote145 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
2 votes160 views2 answers
Mysql count rows returned
SQL
0 vote157 views1 answer
Change filed order in mysql
SQL
0 vote167 views1 answer
Import mysql'
SQL
5 votes156 views1 answer
Oracle sysdate
SQL
0 vote151 views1 answer
Close sql query vb.net
SQL
3 votes158 views1 answer
Postgresql db owner change
SQL
1 vote153 views1 answer
Truncate left characters mysql
SQL