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.
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 in the model space, but not on the diagram objects themselves.
With this now un-checked, the diagram appears as:
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.