Visio 2019 reverse engineering doesn't show foreign keys in my diagram

Question

I'm working on creating an ER diagram for one of my oracle database schemas and I'm able to reverse engineer the database where I can see all the tables I want, but when I drag 2 tables that are parent/child to one another, there is no relationship being displayed. There is no connection line between them and the child table doesn't show the "FK" annotation.

Am I missing some display setting or option that is causing this issue? I'm using an Oracle 19c database.

Thank you for any help

Answer 1

If figured out the issue. I have multiple oracle clients and it was using 11g not 19c as I had intended. I uninstalled 11g and then created an ODBC to my schema and this time when I dragged the tables it should all of the information I wanted.

Thank you for your help

Answer 2

Hi @JERRY Warra ,
Did you create the relationship for 2 tables?
Refer to this support article about "Define a relationship in a Database Model diagram":
https://support.microsoft.com/en-us/office/define-a-relationship-in-a-database-model-diagram-e81d162b-65a1-4f2e-b57c-ee8a17de877e

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Yes the tables already have the relationship within oracle. In the past I would reverse engineer and then select the 2 tables and drag them to the grid and it would should both tables with the line showing there is a relationship. This has been really perplexing since it has worked with the same schema in the past. Is there any issue with Oracle 19c and Visio 2019 when it comes to showing relationships?

Within Visio 2019 when I highlight a table it has small circles with slashes through them at 8 different points on the border of the table. Is this an indication of some issue?

Thank you