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 vote218 views2 answers
Suse Linux restart MySQL
SQL
0 vote199 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
7 votes216 views1 answer
Show line number in sql server
SQL
0 vote189 views1 answer
Select a row include list of array with join table SQL
SQL
2 votes184 views2 answers
Run mysql command from bash
SQL
4 votes205 views3 answers
NOT NULL SQL
SQL
0 vote140 views1 answer
Now() -1 mysql
SQL
7 votes203 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
8 votes196 views1 answer
Check mysql version phpmyadmin
SQL
0 vote196 views1 answer
Command to give readonly access to a postgres sql user
SQL