OraFAQ Forum: SQL & PL/SQL » Sql Query to retrive Priamry Foreign Key field of Table

Home » SQL & PL/SQL » SQL & PL/SQL » Sql Query to retrive Priamry Foreign Key field of Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Query to retrive Priamry Foreign Key field of Table [message #21807]

Sun, 01 September 2002 18:58

Shridhar
Messages: 4
Registered: November 2001

Junior Member

Hi..
I am workin on Appliaction Project I need a Sql Query to fetch Primary Key,Foreign Key, other Contraints FieldNames and as well as Constraint name from the Table.
Note that that not by not viewing the Table structure by desc tablename command on Sql Prompt

Please if anyone come across the solution mail me back asap
Thanks for your Help in advance

Regs,
Shridhar

Report message to a moderator

Re: Sql Query to retrive Priamry Foreign Key field of Table [message #21809 is a reply to message #21807]

Sun, 01 September 2002 22:44

Puneet Vats
Messages: 33
Registered: June 2002

Member

Dear,

You can do it with the help of user_constraints and user_cons_colums.
now it is ur ability of joins for retreaving data.
if u can not do it then mail me at vats_puneet@rediffmail.com

ok bye

Report message to a moderator

Previous Topic:	To find greatest in a row
Next Topic:	calculates the deduction sal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:45:53 CDT 2024