The ER Diagram tool offers a visual representation of database relationships. This is very useful when studying a set of tables for use and building queries. To use the ER Diagammer, drag tables from the object palette onto the viewing area. The diagram will add the dependent tables and their relationships.. This article will show you how to generate Entity-Relationship Diagram (ERD) in Toad for SQL Server.. Click Diagram icon or choose from menu Tools -> Diagram.; You can build a diagram by drag and drop tables/views from object explorer to database diagram workspace. Another way is select multiple tables you want to have in a diagram, then right click in object explorer -> Send To -> Database.
To add tables to an ER Diagram in Toad 8.5.x and above: 1. Open the diagram tool by selecting Tools | ER Diagram (Toad 8.5.x to 8.6.x) or Database | Report | ER Diagram (Toad 9.x and above). 2. To add tables, you will need either of the following visible: * Schema Browser * Project Manager * Object Search window * Object Palette. 3.. The DBA Edition of Toad for Oracle is a package that contains the Toad Data Modeler, if that's what you are referring to. Even without the Toad Data Modeler, any Toad edition can always generate an ER diagram from any object or set of objects (e.g. right-click object/s within the Schema Browser LHS and and choose ER Diagram, per screen snap below).