ThatJeffSmith

How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler

Today’s question:

Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ?

Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing about 90 tables.

By default SQL Developer shows the schema in the diagram

By default SQL Developer shows the schema in the diagram

Our user doesn’t want to see the “SCHEMA.” notation in the model diagram, but doesn’t want to lose the actual schema definition.

The wrong way to handle this would be to one-by-one, unset the schema reference…this would ‘fix’ the issue, but you’d have to do it for every table in your model and other issues would arise.

So, the RIGHT way to do it is to mouse-right-click in the diagram:

Right-click, ‘Show Details’

Right-click in the model space, but not on the diagram objects themselves.

Too much info? Hide the clutter with these diagram visual toggles.

Too much info? Hide the clutter with these diagram visual toggles.

With this now un-checked, the diagram appears as:

The schema notation is gone from the diagram, but NOT from the model

The schema notation is gone from the diagram, but NOT from the model

You can also use this feature to hide the data types by the column names or only show columns that are primary or foreign keys. And then after you hide a bunch of stuff, you’ll want to re-size your diagram objects.