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 vote241 views1 answer
Group by sql not ordering issues
SQL
3 votes222 views1 answer
Oracle user quota unlimited
SQL
1 vote259 views2 answers
Sql server backup table
SQL
6 votes244 views2 answers
Non relational database
SQL
0 vote248 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote182 views1 answer
Microsoft sql server management studio clear cache
SQL
-1 vote220 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote222 views1 answer
Sqldf change user
SQL
0 vote223 views1 answer
Take sql dump in to file
SQL
0 vote260 views1 answer
Ajouter une clé etrangere mysql
SQL