Generating Entity Relationship Diagrams
Sometimes a DBA or developer would like a mini-ERD (entity relationship diagram) for just a few tables of interest. For example, the developer might be writing code against a set of tables and would like to have a roadmap of their structure to code against. Having such a diagram can increase productivity while decreasing errors. For those shops that have a data-modeling tool such as Quest Software’s QDesigner, this is no problem. But if your shop just has TOAD, you can still create basic, simple ERDs using the SQL Modeler (although indirectly). However, the process is significantly different than modeling SQL code as covered in the preceding section.
First, you merely select a table of interest in the ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
