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

10 votes147 views2 answers
What is database
SQL
15 votes147 views5 answers
Select all tables sql
SQL
0 vote140 views1 answer
Custom row number
SQL
1 vote144 views1 answer
Postgres left join
SQL
0 vote130 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote129 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
4 votes139 views1 answer
Oracle show errors
SQL
0 vote94 views1 answer
Mysql find foreign key references
SQL
0 vote132 views1 answer
Get null value in sql
SQL
16 votes155 views5 answers
Select last row in sql
SQL