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

16 votes177 views3 answers
Delete row psql
SQL
0 vote189 views1 answer
Apt install sql server
SQL
0 vote193 views1 answer
Update top 100 order by sql server
SQL
0 vote180 views1 answer
Mysql xampp reset root password
SQL
0 vote176 views1 answer
Mysql read row
SQL
5 votes204 views1 answer
Oracle generate list of dates in between a date range
SQL
3 votes191 views6 answers
DB::table('users')->get();
SQL
0 vote182 views1 answer
Ansi sql count duplicate rows
SQL
1 vote186 views1 answer
Sql try catch
SQL
0 vote189 views1 answer
How to check common records in 2 table
SQL