Re: SQL to view Table Relationships?

On 22 Jul 1999 11:50:42 -0400, Scott Murray <smurray_at_officecomp.com> 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]

Look in user_cons_columns. R_CONSTRAINT is the constraint name for the referenced column(s) in the parent table.

>;
>
>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

--

It helps the car, in terms of end user complexity and engineering, that a car is not expected to suddenly become wood chipper at some |||

arbitrary point as it's rolling down the road.                       / | \
						                       
			Seeking sane PPP Docs? Try http://penguin.lvcm.com