Re: Documenting databases

From: Daniel Hanks <hanksdc_at_about-inc.com>
Date: Tue, 09 Dec 2003 15:09:28 -0800
Message-ID: <F001.005D953C.20031209150928@fatcity.com>

On Tue, 9 Dec 2003 alan.aschenbrenner_at_ihs.com wrote:

> Recently our database manager has asked us to do the unthinkable....
> document our databases! To make matters worse, and without our input, he
> went ahead and created a schema and put it in an Access database (using
> tables to make it look like a speadsheet). Either we use his idea or come
> up with something else.
> So, I thought I'd ask everyone on the list how you do it. Text files?
> In a database (oracle, or other)? Spreadsheets? What are the pros and
> cons? Etc....
>

How about in each database itself.

COMMENT ON TABLE|COLUMN tab|tab.col IS '...'

comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation...

HTH,

Dan
Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: hanksdc_at_about-inc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 09 2003 - 17:09:28 CST