Re: Is There Any SQL*Plus Command To Display Table Relationships?
Date: Mon, 04 Feb 2002 13:09:06 GMT
Message-ID: <3c5e85fe.16501239_at_news.btclick.com>
Hi Daniel
On 2 Feb 2002 22:05:19 -0800, aleatory_at_hotmail.com (aleatory) wrote:
>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.
You could use the DataBee software for this. It will pick up foreign keys as a matter of course and contains a number of tools to find, record and display relationships between tables. (column searching, relationship chains, whois-parent-of-what, etc).
Disclaimer: DataBee is not free (it is a commercial subset database cutting product) however you do get a 30 day free trial which should enable you to get done what you need to do.
DataBee: http://www.databee.com
Regards
Dale Edgar
Dale_at_DataBee.com
DBATool: an essential part of any DBA's toolkit. Get your free copy from http://www.databee.com/dt_home.htm Received on Mon Feb 04 2002 - 14:09:06 CET