Re: Naming Convention for Columns

Alvin Sylvain wrote: > > Billy Verreynne <vslabs@onwe.co.za> wrote in article > <6e2mq3$loa$1@hermes.is.co.za>... > > Jim wrote in message <6e0rmf$1216$1@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.