RE: Naming Convention for Informix Database Objects

I think you seem a tad upset there. Maybe because someone got the better of the clown? -----Original Message----- From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] Sent: Friday, November 21, 2003 12:57 AM To: informix-list@iiug.org Subject: RE: Naming Convention for Informix Database Objects Dusty Haas wrote: > Shouldn't indices be - this_is_an_index_called_ instead of a_index_? > > Just a curious thought You're quite right to do that nit pick and I do feel just like a right dick your razor sharp eyes affirm the surmise "to cut and paste is lazy and thick" > -----Original Message----- > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > Sent: Thursday, November 20, 2003 12:50 PM > To: informix-list@iiug.org > Subject: Re: Naming Convention for Informix Database Objects > > Christopher wrote: > >> Can anyone recommend a good naming convention for database objects in >> Informix? >> >> Generally, I use my own variation on Hungarian, but I wondered if >> there is an equivalent of the RVBA (also known as Leszynski/Reddick) >> standard among Informix developers. >> >> I would also be thrilled to find a write-up I can reuse or just plain >> plagiarize. >> >> As an aside, this is to be implemented on IDS 9.4, so long identifiers >> are not an issue. > > I generally prefix tables with this_is_a_table_called_, views with > this_is_a_view_called_, indexes with this_is_a_index_called_ ... > -- "C'est pas parce qu'on n'a rien a dire qu'il faut fermer sa gueule" - Coluche sending to informix-list