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 vote140 views1 answer
Get null value in sql
SQL
2 votes126 views1 answer
Wait delay in sql server
SQL
-1 vote129 views1 answer
Add column alter table default value
SQL
3 votes96 views1 answer
If 0 return null else return query mysql
SQL
1 vote150 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
-2 votes135 views1 answer
How to open database
SQL
0 vote147 views2 answers
How to display enum value sql server
SQL
0 vote136 views1 answer
Mysql match in serialized data
SQL
5 votes147 views1 answer
Get column name sql server
SQL
0 vote148 views1 answer
Sql get highest date from 3 tabels
SQL