Get primary key of table

SELECT a.COLUMN_NAME
FROM all_cons_columns a INNER JOIN all_constraints c 
     ON a.constraint_name = c.constraint_name 
WHERE c.table_name = 'TBL'
  AND c.constraint_type = 'P';

Similar codes

0 vote146 views2 answers
Android sqlite query join
SQL
0 vote176 views1 answer
Add column not null with default value postgres
SQL
2 votes197 views3 answers
Current setting postgres timezone
SQL
2 votes256 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote192 views1 answer
SQL Where-Klausel
SQL
1 vote176 views1 answer
Rename table column name in mysql
SQL
1 vote383 views1 answer
How to make a select in sql
SQL
20 votes171 views1 answer
Sql change column types
SQL
0 vote165 views1 answer
Insert or update cassandra
SQL
1 vote169 views2 answers
Extract weekday from date in sql
SQL