Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

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

2 Mins Read

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.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

10 Comments

  1. Ash Reply

    Thanks Jeff, this was super helpful! I was dreading having to do this one at a time! 🙂

    BTW, the settings for column level to show/hide are not really that intuitive. I had to check/uncheck a few things under the View Details. checking/unchecking Datatype did not do anything initially. I finally got it to work by clicking on Names Only, then only checking Columns.

  2. Meghan Reply

    Is there any way to similarly remove the schema notation in generated PDF reports? I followed these instructions and it’s not displayed in the diagram, but is still included in the report.

    Thanks!

    • thatjeffsmith Post Author

      I’m with my daughter at the dentist, but I’m confident we can do this. The reporting is crazy customizable…are you saying the data dictionary PDF reports are showing the schema or the diagrams in the PDFs are?

    • Meghan

      The data dictionary reports are showing it. I’m actually digging into the customization options at the moment to see if I can figure it out, but wanted to check if there was a ‘quick and dirty’ way to exclude them, similar to your instructions for the diagrams.

Write A Comment