Re: Descriptions for Table Fields

A copy of this was sent to mark m <mockm_at_my-deja.com> (if that email address didn't require changing) On Tue, 27 Jul 1999 13:05:16 GMT, you wrote:

>good day!
>
>one of my colleagues and i were wondering if there are locations for
>descriptions of field within tables. for instance, i create a table
>with five fields. each field has a name, a size, a type. is there a
>way to store within the table structure?
>

see the COMMENT command in the SQL reference manual. briefly:

COMMENT
To add a comment about a table, view, snapshot, or column into the data dictionary.
The table, view, or snapshot must be in your own schema or you must have COMMENT ANY TABLE system privilege.

>i am using embaradero's er/studio to reverse engineer our database for
>ERDs once it is created oracle server (7.3.4.0). the app does reports
>too. we were hoping to eliminate documentation updating by having the
>app generate the reports. but we need descriptions on each field in
>every table. is this message clear or did i kluge it up?
>
>mark
>
>~~~~
> mark m @ team health
>~~~~
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jul 27 1999 - 08:44:52 CDT