Re: simple reverse engineering of schema using table and column comments
- From: Jared Still <jkstill@xxxxxxxxx>
- To: identd@xxxxxxxxx
- Date: Tue, 16 Nov 2004 10:51:07 -0800
This would be fairly easy to do your self with some basic
data dictionary queries, sqlplus and 'SET MARKUP HTML ON'.
HTH
Jared
On Mon, 15 Nov 2004 23:00:57 -0800, Marc Slemko <identd@xxxxxxxxx> wrote:
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
