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

1 vote212 views1 answer
OstgreSQL version
SQL
1 vote167 views1 answer
Into sql
SQL
1 vote211 views1 answer
Sql upsert
SQL
5 votes215 views1 answer
Get column name sql server
SQL
0 vote196 views1 answer
Object Information
SQL
2 votes220 views1 answer
Q operator in oracle
SQL
0 vote238 views1 answer
Add user mysql wordpress
SQL
0 vote216 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote217 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote201 views1 answer
Optimize sql query
SQL