Home » RDBMS Server » Server Administration » Where is Primarykey and Table Structure stored?
Where is Primarykey and Table Structure stored? [message #53187] Sun, 01 September 2002 22:12 Go to next message
Shivakumar
Messages: 6
Registered: May 2000
Junior Member
Hi, Can anybody tell me where the PrimaryKey fieldnames and Table Structure(fieldnames) are stored in the Oracle database.
Thanx
Shiv

Report message to a moderator

Re: Where is Primarykey and Table Structure stored? [message #53189 is a reply to message #53187] Mon, 02 September 2002 03:14 Go to previous message
Manju
Messages: 10
Registered: November 2000
Junior Member
Hi,
Are you looking for the metadata from the dictionary?
If so you can try this statement

select substr(a.column_name,1,35),a.position,b.constraint_type from user_cons_columns a, user_constraints b where a.table_name = 'XYZ' and a.constraint_name = b.constraint_name and a.table_name = b.table_name and b.constraint_type = 'P'

Hope this helps

Cheers,
Manju

Report message to a moderator

Previous Topic: password file and oradim
Next Topic: how to increase the performance of the server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 21:08:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.