Clever Geek Handbook

How to hide foreign key elements from tables in SQL Developer Data Modeler?

For example, I have two tables UNIT_OF_MEASUREMENT

and PHYSICAL_QUANTITY

. PHYSICAL_QUANTITY

has a field representing the foreign key of the table UNIT_OF_MEASUREMENT

. When I add this relationship, the PHYSICAL_QUANTITY_UNIT_OF_MEASUREMENT_FK

at table is displayed PHYSICAL_QUANTITY

. How can I hide this element (not a relation) from the table? enter image description here

There is a way to hide the primary key elements from the table. Just right click on the table → select Show / Hide Items → select the items to be hidden and click OK.

enter image description here

But the element PHYSICAL_QUANTITY_UNIT_OF_MEASUREMENT_FK

is not displayed there. What for? And is there a way to hide the item PHYSICAL_QUANTITY_UNIT_OF_MEASUREMENT_FK

from the table? Thank.

+3


source to share


2 answers


You can select the items you want to display by right clicking on the chart (not tables) and selecting the ones you need in View Details



enter image description here

+1


source


Bad answer For some reason, Data Modeller generates horrible long string names for FK and there is no way to hide them from the display, which is bad.



0


source






More articles:


All Articles