[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
I encounter an naming error when SCHEMA1.TABLE1 references to SCHEMA2.TABLE2, from the References view, it should display SCHEMA1.TABLE1--->SCHEMA2.TABLE2 but the DbVisualizer 4.5 display it as [b]SCHEMA2[/b].TABLE1--->SCHEMA2.TABLE2.
If the referenced table is from same schema, the References View will be fine. What the problem if the referenced table is from different schema, Reference View will always display the wrong schema name like OTHERSCHEMA.MAINTABLE--->OTHERSCHEMA.OTHERTABLE which supposely MAINSCHEMA.MAINTABLE--->OTHERSCHEMA.OTHERTABLE.
I have attached a generated References table file. From the screenshot, there are 4 relationships for table XERMADM.HOST. 3 relationships are link to same schema's tables and 1 relationship is linked to different schema's table. The error here is happened in that relationship that linked to different schema's table, XERMSYS.S_COUNTRY. It displayed as XERMSYS.HOST--->XERMSYS.S_COUNTRY which should displayed as XERMADM.HOST--->XERMSYS.S_COUNTRY.
Hope you guys look into this problem. Thanks.