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

3 votes322 views1 answer
Insert into table from another table mysql
SQL
0 vote349 views1 answer
Create boolean column in MySQL with false as default value?
SQL
2 votes310 views1 answer
Mysql auto increment jumping
SQL
7 votes353 views1 answer
Mysql iif
SQL
0 vote356 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote325 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
31 votes322 views3 answers
Sql count
SQL
3 votes338 views2 answers
Df to sql pandas sql achemy
SQL
0 vote324 views1 answer
Order by number of character in sql
SQL
9 votes341 views6 answers
Sql add column with default value
SQL