Re: Any database diagramming tools out there ?

> Where are looking for a tool which will show the relationships between a
> table and all its related objects such as triggers, views, procedures,
> etc.
>
> We already have TOAD which shoes these relationships in a tabular form
> but we are after a utility which would have the ability to show these
> relationship in something similar to an E-R diagram so that it could be
> printed off and given to project teams.
>
> We are interested in any recommendations anyone in the Oracle community
> would have.

That was my problem too. Disgusted by the lack of diagramming tools, I decided to create my own. Here you can find a script which does simple ER diagrams from the DB schema:

http://mgogala.byethost5.com/er_diagram.zip

It's a Perl script, which you can use as is. I use it when my boss asks me to present him with the ER diagram of a schema. So far, he has been satisfied by the output. No guarantees of suitability for any particular purpose. The script is extremely simple and uses the GraphViz software, available here: http://www.graphviz.org
You are also welcome to change it, if needed. The script could use improvements. It should show table columns and label the arrows with the foreign key constraints but I don't have the need for that right now.

-- 
http://mgogala.byethost5.com