2

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.

Thomas Buckley
  • 5,836
  • 19
  • 62
  • 110

1 Answers1

4

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.

Phil
  • 2,392
  • 18
  • 21