Re: SQL to View Table Relationships?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 23 Jul 1999 09:16:21 -0700
Message-ID: <37989555.360C855D@us.oracle.com>

Change the new_demo bit to NEW_DEMO. Data in the ALL_ views is uppercase.

HTH Pete

Scott Murray wrote:

> I am stumped trying to display the relationships between tables (i.e.,
> which tables have foreign keys to which tables).
>
> I've tried using:
>
> select * from all_tab_columns
> where owner = 'new_demo' [that's my user name]
> ;
>
> and some similar commands, but I keep getting no records found.
>
> Can anyone help me out?
>
> Thanks in advance,
>
> Scott Murray
> smurray_at_officecomp.com

--
Regards

Pete

Received on Fri Jul 23 1999 - 11:16:21 CDT