simple reverse engineering of schema using table and column comments
- From: Marc Slemko <identd@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Nov 2004 23:00:57 -0800
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
