Oracle Database showing existing tables and their relationships .

Hi ,

Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database ?

I am using Oracle as Database .

TOAD is a huge player in this space. I'm personally fond of DbVisualizer.

Thank you very much .

A bit late, I know, but just in case anybody else wants to do this...

TOAD is great, but it's also very expensive.

As an alternative, you could try Oracle's free SQLDeveloper Data Modeler.

This is a pretty good data modelling tool that allows you to import an existing model from a database schema or from other tools e.g. Oracle Designer. You can then view and maintain the model easily via the diagramming tools.

It's easy to install and get started with, costs nothing, and it provides a lot of functionality for data modelling, DDL generation and so on.