Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> simple reverse engineering of schema using table and column comments

simple reverse engineering of schema using table and column comments

From: Marc Slemko <identd_at_gmail.com>
Date: Mon, 15 Nov 2004 23:00:57 -0800
Message-ID: <966249650411152300114e88c4@mail.gmail.com>


Does anyone have any pointers to any tools that can take a schema with comments (added by "comment on", visible in "user_col_comments", etc.) and reverse engineer it into a simple document describing table and column types, constraints and comments, etc.?

I'm not really looking for a full blown modelling tool (although references to ones that can create or reverse engineer descriptions from Oracle comments would still be useful), but rather something more along the lines of some scripts that spit out HTML or some such.

I'm trying to put together a small incremental step beyond the "well, here is the DML used to create the tables, that is all the documentation there is" level of data modelling without requiring much effort or requiring tools for developers to maintain it beyond a text editor. Using Oracle's comment for descriptive information on tables and columns seems like a potentially reasonable first step.

Thanks for any suggestions.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 16 2004 - 00:56:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US