Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to figure out the relationships between tables by querying view USER_CONSTRAINTS ?
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
![]() |
![]() |