Re: Is There Any SQL*Plus Command To Display Table Relationships?

From: Jac <jacxine_at_yahoo.com>
Date: Fri, 15 Feb 2002 11:12:06 +0300
Message-ID: <a4ifso$3lo2_at_medusa.qualitynet.net>


Try using DBA_CONSTRAINTS
HTH
Regards
[Quoted] "G. Pole, P.Eng." <g.pole_at_home.com> wrote in message news:p6na8.372664$pa1.87349757_at_news3.rdc1.on.home.com...
> I have always used Microsoft Access, via an ODBC connection. It's a good
> graphical tool and easy to use.
>
>
> "aleatory" <aleatory_at_hotmail.com> wrote in message
> news:a68a4ee0.0202022205.18dc5e3_at_posting.google.com...
> > Hi,
> >
> > I'm looking for SQL*Plus command to display table
> > relationships. (Primary-Foreign keys, one-to-one,
> > one-to-many, many-to-many, etc.)
> >
> > I usually have no problem when I deal with two or
> > three tables; however, when I have to deal with more
> > than four or five tables, I very often produce
> > cartesian products.
> >
> > Desperately need help on joining tables...
> >
> > Thanks in advance!
> >
> > alea
>
>
Received on Fri Feb 15 2002 - 09:12:06 CET

Original text of this message