Sql developer er diagram

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.

Toad data modeler

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 ...