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

18 votes318 views3 answers
Mysql query add column with default string value
SQL
1 vote327 views1 answer
How to test for sql injection
SQL
0 vote303 views1 answer
Mysql function variable
SQL
0 vote313 views1 answer
Check sql database table lock
SQL
0 vote351 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote302 views1 answer
Sql examples from your work
SQL
0 vote310 views1 answer
Oracle merge insert if not exists
SQL
1 vote309 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote354 views1 answer
Oracle see column type
SQL
0 vote291 views1 answer
Downgrading sql localdb visual studio
SQL