Re: Documentation of databases.
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