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

Exactly. In my experience very few WHERE relationships are codified with Foreign Keys: More should be ... than are.

Daniel Morgan

MarkyG wrote:

> I *think* i know where Daniel is comming from in his post.
>
> You will definately need the foreign key scripts which are posted in
> this thread to gain an overview of table relationships. You should be
> 80% there using those.
>
> What I have experienced in the past on databases is that you cannot
> gain all the table relationships that way since not all fields are
> linked via foreign keys etc by the DBA.
> Also there are 'implied business' ones as well (e.g If you take a
> substring of a field and link it to another you get some result etc).
> You will only know about this over time once you get cosy with your
> data (and time with DBA work collegues).
>
> Mark
>
> "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C5D4D05.B51CBFE1_at_exesolutions.com>...
> > Once again a foreign key based solution. This is no way to write a WHERE
> > clause.
> >
> > To write a WHERE clause you must do real work and understand the data.
> >
> > Daniel Morgan
> >
Received on Mon Feb 04 2002 - 21:07:58 CET