Home » SQL & PL/SQL » SQL & PL/SQL » schema documentation
icon5.gif  schema documentation [message #196508] Thu, 05 October 2006 12:34 Go to next message
Messages: 1
Registered: October 2006
Junior Member

What mechanisms exists for documenting, on a table-by-table basis and a column-by-column basis, a database design? I know there are a variety of tools for reverse-engineering database schemas into ERDs, but it would be nice if one could add a comment or description field in the database itself to describe each table and column. Then, when the ERD was generated, the human-readable descriptions of the fields are there as well.

Re: schema documentation [message #196517 is a reply to message #196508] Thu, 05 October 2006 13:10 Go to previous message
Messages: 43
Registered: October 2004
You can add comment to tables using the COMMENT statement.

comment on table test is 'this is just a comment on table ';

comment on column test.col1 'this is just a comment on column';

Previous Topic: Date Format
Next Topic: SQL*NET message from client
Goto Forum:

Current Time: Fri Aug 18 19:03:57 CDT 2017

Total time taken to generate the page: 0.38206 seconds