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

1 vote281 views1 answer
Update mysql centos
SQL
0 vote264 views1 answer
Python mysqlclient library not found for -lssl
SQL
14 votes268 views3 answers
SQL trim
SQL
0 vote266 views1 answer
Calculate date and convert to yearsmysql
SQL
-2 votes273 views1 answer
Remove root password mysql
SQL
0 vote338 views1 answer
How to check foreign key constraint in sql
SQL
0 vote254 views1 answer
How to count with except in psql
SQL
0 vote293 views1 answer
Sql missing values
SQL
0 vote273 views1 answer
Postgresql using reserved word as column name
SQL
5 votes292 views1 answer
Purge undo tablespace usage
SQL