oracle get table key

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

Search
showing results for - "oracle get table key"
Gabriele
04 Nov 2019
1SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
2FROM all_constraints cons, all_cons_columns cols
3WHERE cols.table_name = 'TABLE_NAME'
4AND cons.constraint_type = 'P'
5AND cons.constraint_name = cols.constraint_name
6AND cons.owner = cols.owner
7ORDER BY cols.table_name, cols.position;
source
similar questions
oracle get current schemaoracle tables with column namelist foreign key oracleoracle get table schemashow tables in oracleadd primary key constraint in oracleoracle create table primary keyforeign key on table oraclehow to create table in oracle sql syntax example and foreign keyoracle get foreign keys on tableoracle find all tables with column nameoracle list index on tablehow to check last gather stats on table in oracleoracle get table column namesoracle find foreign key dependenciesoracle find constraints referencing a tableoracle db get table sizesoracle all tablesoracle list primary keyoracle get sql id from queryhow to know the character set of an oracle databeshow to check table lock in oracle sql developeroracle desc table primary keyoracle check table lockoracle show grants on tableoracle foreign key reference tableidentify primary key in oracle tableoracle table constraintsoracle function return table
queries leading to this page
get primary key of table oracleget primary key of oracle table queryfind primary key of a table oracleoracle get pk tablestables and primary keys query oracleoracle get field pkoracle find primary keys in a tableoracle get table key