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

18 votes325 views2 answers
Sql comments
SQL
-1 vote281 views1 answer
Mysql how to set update or create
SQL
0 vote333 views1 answer
Backup a table in sql
SQL
0 vote337 views1 answer
Default password for mysql_secure_installation in mac
SQL
22 votes419 views1 answer
Mysql workbench
SQL
0 vote717 views1 answer
Sql field equals multiple values
SQL
23 votes365 views4 answers
How to show all users in mysql
SQL
1 vote366 views1 answer
How to remove identity from a column in sql server
SQL
0 vote322 views1 answer
Mariadb LOAD DATA INFILE
SQL
2 votes343 views1 answer
Columns Present in a table
SQL