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

thatjeffsmith SQL Developer 9 Comments

Tell Others About This Story:

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.

Tell Others About This Story:

Comments 9

  1. 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!

    1. 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?

      1. 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.

      2. thatjeffsmith Post
        Author
    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *