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

[Quoted] 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 - 11:59:12 CET