Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

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:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating