SQL to View Table Relationships?

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 Received on Fri Jul 23 1999 - 05:10:13 CDT