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. |
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. |
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. |
Drag-and-drop from:
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center