SQL Navigator for Oracle 7.5

Chat now with support

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	Print the ER Diagram.
	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:

DB Navigator
- From the tree, drag a single object only.
- From the Details pane, drag a list of objects.
Find objects Dialog
Project Manager