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

-1 vote310 views5 answers
Left join sql
SQL
0 vote278 views1 answer
Add a new column into table
SQL
0 vote253 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote293 views1 answer
Sql create and grant user access to database
SQL
22 votes321 views4 answers
Mysql format date
SQL
2 votes261 views1 answer
Sql update from different table
SQL
4 votes246 views4 answers
Sqlite describe table
SQL
0 vote252 views4 answers
Forenkey code alchemy sql
SQL
4 votes246 views1 answer
Mysql ip address
SQL
0 vote259 views1 answer
Find and replace database table phpmyadmin
SQL