Oninit cdi / Archive
Talk to an expert →

RE: Naming Convention for Informix Database Objects

Posted in 2003

Topics: Versions, Editions & End-of-Life

Dusty Haas — — source: Usenet: comp.databases.informix

Shouldn't indices be - this_is_an_index_called_ instead of a_index_? Just a curious thought -----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

↪ replying to Dusty Haas
Obnoxio The Clown — — source: Usenet: comp.databases.informix

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 ' dire qu'il faut fermer sa gueule" - Coluche

Glossary