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

I'm sorry, but I agree with Sarah....
[Quoted] looking at the original question, he asks...

>I'm looking for SQL*Plus command to display table
>relationships. (Primary-Foreign keys, one-to-one,
>one-to-many, many-to-many, etc.)

Toad will do this.

Simon

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C5D4CCE.1F45ACAF_at_exesolutions.com>...
> TOAD will not do what he wants. It shows existing relationships where
> foreign keys exist. He is looking for relationships required to write
> WHERE clauses. Very different things.
>
> Daniel Morgan
>
>
>
> Sarah Lasbrey wrote:
>
> > have you tried TOAD, I think from memory it has a tab that shows all
> > relationships for the selected table
> >
> > 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 Mon Feb 04 2002 - 12:09:45 CET