Re: Naming Convention for Columns

Alvin Sylvain wrote:
>
> Billy Verreynne <vslabs_at_onwe.co.za> wrote in article
> <6e2mq3$loa$1_at_hermes.is.co.za>...
> > Jim wrote in message <6e0rmf$1216$1_at_ausnews.austin.ibm.com>...
> > > My .02 is is to make columns all uppercase. No underscores.
> > > No confusion. Never.
> >
> > I use numbers, first column is C1, second column C2 etc. Tables are
 T1, T2,
> > .. and stored proc are of course P1, P2 and so on.
>
> Hey, I can do you one better than that:
>
> Start *EVERYTHING* with the *SAME* letter, and follow it with
> a perfectly *RANDOM* number!
>
> I mean, look what you've got here: "C3". Right away, I know it's
> COLUMN THREE!! Ah HAH!!
>
> Now, look at "A83410".
>
> You don't know DIDDLY squat about *this* name!!
>
> >;-)

Everyone knows that one of the rules for normalizing a relation states that column order is unimportant. How could anyone use c1, c2, c3.... as a coulmn naming standard? Nuts.

M. Reed, HCIA Inc. Received on Fri Mar 13 1998 - 00:00:00 CST