Re: How to find out the relationship of tables

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 23 Sep 1998 19:21:43 +0200
Message-ID: <36092E27.B79D6E4@psi.de>

Hi k,

of course you will find the information in the data dictionary (see the view USER_CONSTRAINTS). But it is faster to use a tool for this purpose. Our tool Hora 3 shows the master/ detail relations in a treeview. So you will get a good overview of the relationships in your database. You can download a free trialversion of Hora at http:\\www.keeptool.com.

regards Jan Dieckmann
Jan.Dieckmann_at_keeptool.com

k wrote:

> Hi,
>
> I have another question. Is there a way to find out the relationship
> between the tables of a Database. If yes, how to do it. Thanks for any
> help.
>
> Note: OS is UNIX, ORACLE 7.3
>
> kedda.
Received on Wed Sep 23 1998 - 12:21:43 CDT