ORACLE Tables' Ralationship 1

[desi5pure]

Is there a way to find out about relationship between tables in a dastabase if we don't have ERD (Entity ReationShip Diagram)? Is there a system table(s) that keep track of such information?

 

[kutz13]

You could try looking at TOAD Data Modeler:

http://www.toadsoft.com/toaddm/toad_data_modeler.htm

 

[Toe]

well there's the sys table 'all_constraints' which you can query.

or as above post suggests, the 'TOAD' application has some nice tabs on on the schema browser when viewing a table - one for contrainsts and the other general references (shows both parent and child tables)

Oracle designer provides tools for reverse engineering as well