Re: Documentation of databases.

From: Palooka <>
Date: Wed, 26 Nov 2008 19:12:35 +0000
Message-ID: <BchXk.8$Ce6.7@newsfe20.ams2>

kålle wrote:
> Hi everyone.
> Anyone who have knowledge of a application/tool to use when you want
> to document all tables, columns, triggers and so on, all objects in a
> database? Years ago i worked with Designer2000. But i guess and hope
> that there is some lighter/smaller applications who has capabilities
> to do this? Freeware/opensource.
> Regards
> /A

I have long held the view that documenting tables and columns in an Oracle database is largely a waste of time. The database is self-documenting. Why rely on a possibly out of date document instead of querying DBA_OBJECTS and so forth? Comment on table, comment on column...

ERDs, *logical* design, and documents identifying the *reasons* for design decisions are exceptions to this.

However, I am well aware that our lords and masters like to have the comfort of 'documents' which are outside the database. There are many tools, but I have found Schema Spy particularly useful.

Palooka Received on Wed Nov 26 2008 - 13:12:35 CST

Original text of this message