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 vote190 views1 answer
Character count sql
SQL
-1 vote178 views3 answers
SQL to LINQ converter
SQL
0 vote183 views1 answer
Can sqldatareader be null
SQL
0 vote180 views1 answer
Postgres in operator with comma separated values
SQL
2 votes172 views1 answer
Mysql how to store lat,lng
SQL
4 votes185 views1 answer
Oracle session date format
SQL
17 votes199 views4 answers
Show tables sql server
SQL
0 vote204 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
9 votes170 views1 answer
Identity insert on sql server
SQL
0 vote179 views1 answer
Mysql isshow
SQL