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 vote317 views1 answer
Create user faunadb
SQL
0 vote291 views1 answer
Returning with sqlalchemy
SQL
0 vote286 views1 answer
Postgresql heritage
SQL
0 vote271 views1 answer
Bash block size ls /var/lib/mysql
SQL
56 votes537 views5 answers
Psql create user
SQL
4 votes266 views1 answer
Postgresql show current database
SQL
0 vote312 views1 answer
Mysql where don't have string
SQL
0 vote290 views1 answer
Search column name sql
SQL
0 vote291 views1 answer
Linebreak sql
SQL
0 vote359 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL