ThatJeffSmith

Configuring Display of Model Relationships in Oracle SQL Developer Data Modeler

The end goal for many users of Oracle SQL Developer Data Modeler is a a nicely formatted, easy to read diagram. Diagrams are composed of two primary components:

  1. Tables or Entities
  2. Relationships

Today’s post is all about how to manage the display of the relationships.

How can I move the lines around?

You might not like the default anchor point positions of the relationship lines. You can easily move these, but there’s a slight ‘trick.’ Believe it or not, I have seen several modeling tools where this is nigh impossible.

Select the relationship. Move your cursor over the anchor point. When the cursor switches to ‘cross-hairs’ mode, then you can drag the anchor point to your new location. Maybe a video would help?

Click, hover, click, and drag.

Click, hover, click, and drag.

But I want to move the entire line at once!
Ok, then ctrl-click on the line, this will add an intermediary point, or an elbow.

Select the line, then ctrl-click, and drag. This adds an 'elbow.'

Select the line, then ctrl-click, and drag. This adds an ‘elbow.’

How can I display the relationship names in the diagram?

It’s a ‘Show’ option. The relationship names are referred to as ‘labels’ in SQL Developer. So right click in the model, go to ‘Show’ and toggle on ‘Labels.’

Default, No Labels

No labels, what you'll see 'out of the box.'

No labels, what you’ll see ‘out of the box.’

With Labels

The relationships are now 'labeled.'

The relationships are now ‘labeled.’

How do I change the Font and Color of the Labels and Lines

The default font face and color for the labels and the line width and colors for relationships are configured in the preferences.

Tools - Preferences - Diagram - Format

Tools – Preferences – Diagram – Format

So very quickly I can make something very, very ugly.

I'm not much of an artist, unless you count sandwiches as a medium.

I’m not much of an artist, unless you count sandwiches as a medium.

You can manually override the display format of any relationship. Just right-click on the line and select ‘Format.’ You can then change the line width and/or color. If you right-click on the label, you can do the same ‘Format’ and change the text color and font settings.

Update: November 11, 2014

Since this post was written, a new version has been released. You can now find the design properties and formatting stuff discussed above in teh following location.

If you're in version 4.0 or higher, look here...

If you’re in version 4.0 or higher, look here…