Does TOAD offer a report or display on tables that have referential integrity to other tables? i.e. What can be used in Toad to show which tables reference or are referenced by other tables?
Feature 1:
Schema Browser | tablename | Right Hand Side - 'Referential' tab displays both Child and Parent tables. The details can be printed or copied as HTML or text to the Clipboard by right clicking the results pane.
Feature 2:
Schema Browser | tablename | 'Constraints' tab displays the actual foreign key contraint details (Type: Referential Integrity).
Feature 3:
Schema Browser | tablename | right click | ER Diagram - provides a graphical display in the form of an Entity Relationship Diagram. This can be exported as a graphical file by right-clicking the diagram | 'Export to Graphic File'
Feature 4:
Database | Report | HTML Schema Doc Generator provides an html document. When clicking on a table, details are expanded to show the referencial integrity: