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

0 vote275 views1 answer
Mysql case when null
SQL
0 vote280 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes368 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes265 views2 answers
Oracle sql group by date year
SQL
0 vote229 views1 answer
Oracle list all stored procedures
SQL
12 votes250 views1 answer
How to change the value of a table in sql
SQL
3 votes257 views3 answers
Remove all spaces from string sql
SQL
0 vote252 views1 answer
Sql get user account
SQL
0 vote258 views1 answer
Safe mysql
SQL
16 votes275 views3 answers
Jwt secret key generator laravel
SQL