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

[Quoted] 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 Sun Feb 03 2002 - 15:44:30 CET