Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to figure out the relationships between tables by querying view USER_CONSTRAINTS ?

Re: How to figure out the relationships between tables by querying view USER_CONSTRAINTS ?

From: Jan Dieckmann <J.Dieckmann_at_psi-bt.de>
Date: Tue, 10 Jul 2001 15:07:33 +0200
Message-ID: <9ieukq$tvs$1@wrath.news.nacamar.de>

If you are looking for a graphical presentation of this information look for ER Diagrammer and Hora of the company KeepTool. See www.keeptool.com for a free 30 days trial version.
Jan Dieckmann

Jennifer Chang <jchang_at_uxb2b.com> schrieb in im Newsbeitrag: 9ib7ts$9mp$1_at_news.seed.net.tw...
> Hi,
> I want to figure out the relationships between a couple tables. The
 only
> thing I knew was to query USER_CONSTRAINTS,
> but all I got were names of constraints, not the column names of primary
> key/foreign key of a table.
> Please help, thank you very much.
>
>
> Jennifer Chang
>
>
Received on Tue Jul 10 2001 - 08:07:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US