Re: Naming Convention for Informix Database Objects

Obnoxio The Clown wrote: > 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_ ... ...And jokes with this_is_a_joke_ ... You shouldn't use your powers over the weak-minded for evil, Luke! I'm looking at a variable name in some 4GL code at the moment called g_f_or_p. Guess what values it generally contains? Now do you think I need to change it's name if I change it's contents?... Give people enough rope (chars), ... Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list