Re: Descriptions for Table Fields

Hi, Mark.

        Try this and see if it gives you what you're after: "select * from user_tab_columns order by table_name, column_id"

Hth,
-Jeff Guttadauro

On Tue, 27 Jul 1999 13:05:16 GMT, mark m <mockm_at_my-deja.com> 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?
>
>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.
Received on Tue Jul 27 1999 - 08:48:59 CDT