Re: need help finding out which tables reference a table

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/10/25
Message-ID: <3270bd60.43763178@dcsun4>#1/1

On Fri, 25 Oct 1996 15:44:51 -0400, opike_at_wttf.com wrote:

>Does anyone know where oracle store information about references.
>Specifically i am looking for a way to see the relationships for a
>table. Who references it and stuff like that. I am using oracle 7.2
>
>thanks
>Orville
>opike_at_wttf.com

the data dictionary views user_dependencies and all_dependencies have this information....

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Oct 25 1996 - 00:00:00 CDT