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 votes160 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote149 views1 answer
Alter check command
SQL
0 vote140 views1 answer
Oracle drop type
SQL
1 vote142 views1 answer
Sql select table header
SQL
0 vote129 views1 answer
Oracle index hint multiple tables example
SQL
18 votes136 views2 answers
Sql inner join
SQL
8 votes149 views1 answer
Oracle search text in all packages
SQL
0 vote128 views1 answer
Set column width in sqlplus
SQL
5 votes145 views3 answers
MySql get fields of table
SQL
0 vote123 views1 answer
Concat column value of same user in mysql
SQL