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 votes138 views1 answer
Mysql find tables with name
SQL
0 vote168 views1 answer
Rails sql query converstion
SQL
1 vote160 views1 answer
Delete specific row in sql
SQL
0 vote168 views1 answer
Group by max date
SQL
6 votes199 views2 answers
Install psql mac
SQL
2 votes153 views5 answers
SQL trigger
SQL
0 vote162 views1 answer
Sub query in linq
SQL
0 vote152 views2 answers
Oracle sql for each row
SQL
0 vote163 views1 answer
Mysql remove bad character from all fields
SQL
8 votes149 views1 answer
Oracle create datafile
SQL