On Tue, 9 Dec 2003 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).