Table Relationships

[jeremydevries]

Is there another way to see the relationships between all tables other than looking at the schema?

In other words, I would like to be able to determine all the referencing tables and referenced by tables of a table from within a script, and then take appropriate action within the script.

[Deepak Kumar5]

You can query on Tables (sys_db_object) and check the Table and Extends table.

[jeremydevries]

Thanks for the reply Deepak, but unfortunately that doesn't help me determine the "referencing tables and referenced by tables". It only defines the parent table that the table is extending. I need to find all of the tables that a column on the table references and all the tables that have a collumn that references the given table.

[Prateek kumar]

Hello Jeremy

System definition> tables> select your table

In the related links you should be able to find "Show Schema map"

PFA

[jeremydevries]

Thank you for your response, but if you read my original question, I'm looking for a way that is not looking at the schema map. The schema map does not allow me access to the data I need via a script.