get primary key of table

Solutions on MaxInterview for get primary key of table by the best coders in the world

Search
showing results for - "get primary key of table"
Tino
07 Sep 2020
1SELECT a.COLUMN_NAME
2FROM all_cons_columns a INNER JOIN all_constraints c 
3     ON a.constraint_name = c.constraint_name 
4WHERE c.table_name = 'TBL'
5  AND c.constraint_type = 'P';
similar questions
create table with primary keyprimary key in sqlprimary key and unique key in sqlget item by composite primary key mysqlidentify primary key in sql tablewhat is primary keyunique vs primary keyreseed sql table primary keysql primary keyadd primary key to tableprimary key sqlhow to define a composite primary key in sqlget a list of tables and the primary keymysql get primary keys of tablehow to define a non primary composite key in sqlchange primary key sqlprimary key start from numbershow primary key in sqlprimary keyidentify primary key in oracle tablesql find tables primary keyssql change primary key to composite key
queries leading to this page
sql return part of a keyhow to find key in sql tablehow to find primary key of a table in sqlhow to get primary key of a tableget key details of table in sqlfinding the primary key of a tablesql table get primary keycheck primary key in sqlsee table keyshow to retrieve primary key of a tableselect table primary keyfind a primary key sqlhow to find the primary key of a table using sqlsql server select table primary keysql select column primary keyquery to find primary key of a table in sqlselect primary key using flexquerysql server show table primary keyget primary column from table sql serversql server get primary keyhow to find the primary key of a tablesql search data by primary keysql command to show primary keymssql query to get table column with keyshow to show primary key in sqlget primary key of the table sqlselect primary key from table sqlget table keys sqlsql search keyhow to select primary key in sqlhow to select primary keys in sqlsql get table primary keyhow to find primary key table in sql serverhow to get primary key from sql tablesql to get primary key of a tablehow to check the primary key of a tablehow to identify what is primary key from tabledetermine a key in sqlhow to check primary key in table sql serversqk query to dispaly primary keyssql query to get primary key of a tablehow to know primary key of a table in sqlmssql primary key testhow to identify a primary key in a tablefind primary key in a table in sql serverget the table from a keyhow to get primary key of a table in sqlhow to find primary key of table sqlget primary key of tableretrieving data from a sql table based on primary keysql query to get table column data by keyselect a column in sql server as a primary keysql get primary key of tablesqlserver find primary key of tablefind primary key of a tablehow to find primary key of a tablesql how to find primary key of tableretrieve primary keyselect keys in table mssqlsql search by pksee keys of table sqlhow to check primary key of a table in sql serversql server sarch on column keyget primary key from table sql serverhow to see the primary key in a table in sqlquery to get primary key of a table in sqlget table that has primary key sql serverwhere should the primary key be in the table sql command to get the primary key of tablehow to find primary key of a table in sql serverhow to get primary key of table in sql serversql search for keyhow to find out primary key of a table in sqlget primary key sqlselect primary key sql serversql select where primary keysql select primary keyhow to get primary key from tablesql to write get primary key of a tableget primary key of table