Home » Other » General » Primary and Foriegn Key (Orcle 9, Windows)
Primary and Foriegn Key [message #355645] Sun, 26 October 2008 18:19 Go to next message
imri1010
Messages: 1
Registered: October 2008
Junior Member
Hi,

I am new to Oracle. How do I find out a primary might be a foriegn key for another table? Is there table diagram in Oracle?

For example: I saw "Customer ID" in a table, I want to know "this "Customer ID" is linked to what other tables, how I find that out?

Thanks,
Re: Primary and Foriegn Key [message #355665 is a reply to message #355645] Mon, 27 October 2008 00:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query user_constraints or all_constraints view.

Regards
Michel
Re: Primary and Foriegn Key [message #355679 is a reply to message #355665] Mon, 27 October 2008 01:19 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Actually, you'd probably get the answer a little bit faster if you include USER_CONS_COLUMNS into the query as it contains column names.
Previous Topic: DBDiff from DKG Dead?
Next Topic: HELP! Oracle free web account isn't working
Goto Forum:
  


Current Time: Tue Dec 06 00:27:10 CST 2016

Total time taken to generate the page: 0.10182 seconds