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

You can agree. But that does not make you correct. TOAD will only show you foreign keys. Most relationships between tables are not coded into foreign keys.

You are well on your way to a great Cartesian product.

Daniel Morgan

Simon Redmond wrote:

> I'm sorry, but I agree with Sarah....
> 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 - 21:09:02 CET