Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Descriptions for Table Fields

Re: Descriptions for Table Fields

From: Jeff Smith <spamnadajsmith_at_provide.net>
Date: Wed, 28 Jul 1999 07:59:06 -0400
Message-ID: <379EF08A.AA62F09F@provide.net>


I might add that coming from a guy who makes a living modifying code done by others, commenting tables and columns and keeping them updated is a very worthwhile practice, and I, for one, appreciate when others do it! :)

Jeff Guttadauro wrote:
>
> 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 Wed Jul 28 1999 - 06:59:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US