ER Diagram
ER Diagram
The ER (Entity Relationship) diagrammer lets you quickly model a table and graphically see the dependencies and joins to other tables.
|
|
Note: To ensure indexes are delivered in the correct order in a diagram, ensure the Oracle Data Dictionary is queried with DBA Views. For more information, see DBA Dictionary Views. |
ER Diagram Toolbar
| Icon | Tool Tip | Description |
|---|---|---|
 |
New ER Diagram | Opens Create ER Diagram. |
 |
Clear ER Diagram | Clear the ER Diagram window. |
 |
Open File | Open a saved ER Diagram. |
 |
Save File As | Save the ER Diagram. |
 |
Save File | |
 |
Save Diagram as Bitmap | |
 |
Print Diagram | Print the ER Diagram. |
 |
Print Preview | |
 |
ER Diagram Info | Show detail of the ER Diagram. |
 |
Load ER Diagram in the SQL Modeler | For more information on the SQL Modeler, see SQL Modeler. |
 |
Find Table Dependencies |
Show joins between tables. This feature does not add new objects to the diagram; it only finds joins between objects already displayed. |
 |
Refresh Diagram | Refresh the ER Diagram window. |
 |
Scale | Zoom in / out of the window. |
 |
Previous auto-layout / Next auto-layout | Scroll through the layouts. |
ER Diagram Display Area
For each table in the model
| Diagram Part | Description |
|---|---|
| Title Bar | The name of the table and schema it resides. |
| Body Area | The columns in the table, the column type, whether the column is indexed, and icons as applicable and selected in Create ER Diagram. |
| Connector Lines | Lines connect tables that are dependent on each other. Lines have a knob end and an arrow end. The referencing table resides at the knob end, and the referenced table at the arrow end. |
To add tables to the diagram
Drag-and-drop from:
-
- From the tree, drag a single object only.
- From the Details pane, drag a list of objects.
- Find objects Dialog
- Project Manager