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

3 votes188 views1 answer
Oracle sleep
SQL
0 vote169 views1 answer
Join in update query in mysql
SQL
0 vote192 views1 answer
Mariadb disable foreign key checks
SQL
-1 vote183 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
-1 vote178 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote184 views2 answers
Create-toys-table-with-toy_name-column
SQL
1 vote187 views2 answers
One to one and one to many relationship
SQL
10 votes178 views1 answer
Create table oracle
SQL
0 vote192 views1 answer
Restart sql server command line linux
SQL
0 vote199 views1 answer
How to get button for every record from mysql
SQL