My company has an existing Database with dozens of DB tables with various relationships.
Is there any tool available that will generate a relationship diagram?
I primarily use SQL Developer 3.0.4 on an Ubuntu 11.10 machine by the way.
My company has an existing Database with dozens of DB tables with various relationships.
Is there any tool available that will generate a relationship diagram?
I primarily use SQL Developer 3.0.4 on an Ubuntu 11.10 machine by the way.
Copyright © 2021 Jogjafile Inc.
SQL Developer Data Modeller can reverse engineer a database schema & make a start on an ERD using the foreign keys. Obviously some manual work will be needed once the initial import has been done in order to generate a nice looking meaningful diagram.
Since you already have SQL Developer installed, you can make a start with
File->Data Modeller->Import->Data Dictionary
.