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 vote318 views1 answer
Contraint default SQL
SQL
0 vote296 views3 answers
Osx stop mysql service
SQL
18 votes289 views3 answers
Mysql number format
SQL
0 vote251 views1 answer
Expose db in virtualbox
SQL
0 vote310 views1 answer
Create boolean column in MySQL with false as default value?
SQL
31 votes310 views4 answers
Mysql grant execute
SQL
0 vote311 views1 answer
Search from comma separated values in sql server
SQL
0 vote290 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote308 views1 answer
Show the colums of table sql
SQL
0 vote308 views1 answer
Change filed order in mysql
SQL