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 vote234 views1 answer
Select top values sql
SQL
0 vote204 views2 answers
How to display enum value sql server
SQL
0 vote190 views1 answer
Minecraft duping allowed servers
SQL
1 vote203 views1 answer
Md5 encryption for existing records
SQL
0 vote201 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote213 views1 answer
What does leave do in mysql
SQL
0 vote201 views1 answer
Is not null postgresql
SQL
3 votes201 views1 answer
Oracle sleep
SQL
0 vote225 views1 answer
Mysql drop trigger
SQL
2 votes190 views2 answers
Mysql on duplicate key ignore
SQL