| Primary and Foriegn Key [message #355645] |
Sun, 26 October 2008 18:19  |
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 #355679 is a reply to message #355665] |
Mon, 27 October 2008 01:19  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
