SQL Developer - The Universal Database Frontend

Diagram Editor

The Data Model Visualizer

With the diagram editor you can visualize database catalogs and schemas. Predominantly the diagram editor is intended to support reverse engineering of existing databases.

Object list

The object list shows all diagram objects in ascending alphabetically order. For easy recognition of an object its background color is displayed on the left of each list entry. References between the diagram objects are not shown by this list.

Select one or more objects from the list to perform a function on them. The list selection is always synchronized with the selection of the diagram view.

Overview

The overview displays the diagram from the bird's view and shows the visible region of the diagram view with a marker frame. You can use the mouse to modify the frame's size and position to control the zoom factor an the visible region of the diagram.

Diagram view

DiagramEditorSmall_en

The diagram view shows the diagram objects graphically. Select one or more objects from the view to perform a function on them. The selection is always synchronized with the selection of the object list. A selected object is displayed with a dashed selection border and multiple selection handles.

To select multiple objects click on the background of the diagram view with the mouse and hold down the mouse button. By dragging the mouse cursor you span a rubber band you can use to include the objects to select. When you release the mouse button, the objects inside the rubber band bounds get selected.

Hold down the Shift key during selection to add new objects to the existing selection. Hold down the Ctrl key to invert the selection state. Selected objects will be deselected and vice versa.

To move an object, click inside the object's bounds, hold the mouse button and drag the mouse cursor.

To change the size of an object, click on a selection handle of the object and drag it to the desired position.

You can add additional vertexes to a connector line between two objects e.g. to create right-angled connectors. Hold down the Shift key and right-click on the line where the new vertex should be added. An existing vertex can also be removed by holding down the Shift key and right-clicking the selection handle.


Tip See the tutorial on creating a new diagram from imported database objects