The Entity Relationship (ER) Diagram Generator helps users achieve a better understanding
of their database schema by displaying the structure in a graphical format. To view an ER Diagram:
- Launch the ER Diagram Generator dialog by:
- Selecting Tools -> ER Diagram Generator from the Menu Bar OR
- Selecting Tools -> ER Diagram Generator from the right-click pop-up menu on
a database object in the Schema Browser
- Select a Database and Schema (or All Schemas)
- In the left panel, select one or more types of objects to be scripted (Tables, Views or Both).
Click the green check button to select all and the red X button to deselect all.
- All objects matching the selected schema & object types will appear in the right panel.
Select one or more objects to be scripted.
Click the green check button to select all and the red X button to deselect all.
- Click Next to generate the diagram
- Once the diagram is generated, the ER Diagram Viewer will open and display the new diagram.
- To change the layout of the diagram, select an entry from the Layout dropdown list.
Supported layouts include:
- Box
- Circle
- Hierarchical
- Tree
- Radial Tree
- Moen
- Fruchterman-Reingold (FR)
- Annealing
- Inverted Self Organising Map (ISOM)
- The Entity View drop-down list determines the amount of detail displayed for each entity in the diagram.
Select Full to view all attributes or Header to view only the entity name.
- To save an image of the current diagram, click Save Image As.
- To print a hard-copy of the current diagram, click Print.
- Click on an entity to display more column & constraint detail in the lower left panel.
ER Diagram Generator Enhancements:
-
General
-
ER Diagram: Indexed columns are now identified with an icon in the diagram.
-
ER Diagram Generator Dialog - Added "Reverse Selection" to object selection, to reverse the current selection
|
|
