Re: Naming Convention for Columns

Neil Warnock wrote: > In article <ygewwe0eoqm.fsf@cariboulake.com>, > Michael Leo <mleo@cariboulake.com> wrote: > >Jeremy Rickard <Jeremy@SPAM.demon.co.uk> writes: > >> In article <3505ad61.266543@read.news.global.net.uk>, Keith Boulton > >> <boulkenospam@globalnet.co.uk> writes > >> >Having said that, I did work for an organisation once which had DB2 > >> >naming conventions where table and column names were limited to 8 > >> >characters. The first three characters were a system mnemonic, > >> >followed by a five digit number i.e. select xyz00024, xyz00057 from > >> >xyz11003. > >> That's nothing! I worked for an international (US based) company which > >> had one system with 4 character column names. These were abbreviations > >> of the full attribute names - in Norwegian, naturally. > >Hah! > >I once worked for a company that re-used bits that fell out of the > >ends of disconnected cables. If you got your weekly status > >reports in late you were chosen to sort them into piles of '1's > >and '0's. > I'd fire anyone who pulled that kind of s**t working for me. I've got > enough problems using alpha characters without having to worry about what > table/column 01010100 00110011 00101110 01000011 00110100 00110111 > refers to. Pshaw, you think that's something? I'd personally sack, set fire to, and jump up and down on the ashes of whilst swearing loud oaths anyone who created a database product with underlying file names such as aaaaaaab.t00 aaaaaaac.t00 aaaaaaad.t00 aaaaabaa.t00 and that is *just for starters*! Ooh-err. Or something. Richard. -- My newsfeed is erratic :. post+e-mail to be sure I receive your msg. The Open University is not responsible for content herein, which may be incorrect and is used at reader's own risk.