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 vote127 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote148 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote116 views1 answer
Psql attribute cannot login
SQL
0 vote118 views1 answer
Sql select min row
SQL
2 votes138 views2 answers
Set value to null sql
SQL
0 vote121 views1 answer
Mysql grant all on all databases
SQL
0 vote153 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote127 views1 answer
Postgresql custom order by
SQL
0 vote123 views1 answer
Oracle c# multiple update sql
SQL
-1 vote116 views1 answer
Add column alter table default value
SQL