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 vote156 views1 answer
Query only first letter string
SQL
2 votes162 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote140 views1 answer
Create boolean column in MySQL with false as default value?
SQL
3 votes187 views2 answers
Brew restart mysql
SQL
0 vote161 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote171 views1 answer
Oracle list user locked
SQL
0 vote176 views1 answer
Check database restore status sql script
SQL
3 votes171 views1 answer
What is having
SQL
0 vote152 views1 answer
Firebird where
SQL
1 vote174 views4 answers
How to check table in postgresql from terminal
SQL