Re: Data base diagram , help pls

From: Daniel Morgan <>
Date: Wed, 22 Sep 2004 07:44:13 -0700
Message-ID: <1095864327.609324_at_yasure>

Jack wrote:

> Use oracle designer...
> "Raghuraman" <> wrote in message 

>>HI friends,
>>I am new to oracle 9i, but a sqlserver now under
>>oracle.How can i see the relationship between the database tables in
>>oracle in terms of database diagram .
>>Thanks a lot

Or ERwin or dbArtisan or any other third-party product that provides this capability. Unlike M$ ... Oracle does not see at as its mission to put every other software company out of business.

You can also print the information from the data dictionary:


t.table_name CHILD_TABLE,
t.constraint_name FOREIGN_KEY_NAME,
r.table_name PARENT_TABLE,
r.constraint_name PARENT_CONSTRAINT

FROM user_constraints t, user_constraints r WHERE t.r_constraint_name = r.constraint_name
AND t.r_owner = r.owner
AND t.constraint_type='R'
AND t.table_name = <child_table_name>;

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Wed Sep 22 2004 - 16:44:13 CEST

Original text of this message