Re: Naming Convention for Columns

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!! >;-)