Re: Naming Conventions?

Karen Hill wrote:
On Apr 23, 3:15 pm, Bob Badour <bbad...@xxxxxxxxxxxxxxxx> wrote:

Karen Hill wrote:

What do you believe is the best naming convention for tables, columns,
schemas and why?

The one that everybody in the organization understands well. For obvious
reasons.


So there are no standards in SQL for naming? In programming languages
there are hungarian notation (now considered bad), Camel Case, Pascal
Case etc.

For example Hungarian notation applied to SQL would look thusly:

CREATE TABLE tblOrders
(
colOrderNumber INT
colPrimaryKey INT PRIMARY KEY
);



I'm with Bob B on this one, with emphasis on "understands well". Over the years, I've seen a great many people waste a lot of time on naming standards. Another thing I've seen within single organizations is one standard force-fitted on two applications, causing confusion for the long-time users of both apps. I suppose that might have been gotten around with with views, which makes me think that technocrats could have views with one set of names and biz people could have another set. For development I always thought it was a good idea for an environment to implement alternative names outside of the dbms proper. Might be good for continuous regression testing as well prototyping.

This is my way of saying that most naming standards efforts I've seen were performed with an attitude that was somewhere between naive and puerile.

p
.

Relevant Pages

  • Re: Naming Conventions?
    ... So there are no standards in SQL for naming? ... there are hungarian notation, Camel Case, Pascal ... Naming conventions are all about applied human psychology and are more closely related to information architecture than database theory. ...
    (comp.databases.theory)
  • Re: html vs htm
    ... Ah yes OS/2, I have a pile of OS/2 operating system disks that never got installed. ... At the risk of being labeled a myopic programmer of any flavor, could you please cite the "standards" I have failed to seek out? ... A large population employed the more restrictive option in their development environment and another large population employed an unrestricted development environment. ... So that later when the restriction was eliminated, the first group should have been mandated to change all their software, naming, and typing habits to conform to the "standard" established by the latter group? ...
    (alt.html)
  • Re: system-log
    ... get the feeling that there were no standards in place ahead of time. ... There were standard but you must accept that naming is a difficult ... Expressed in this posting are my opinions. ... to opinions held by my employer, Sun Microsystems. ...
    (comp.unix.solaris)
  • Re: Newbie looking for guidance on citing sources
    ... *naming* the entries for sources and repositories. ... firm believer in what we refer to as 'naming standards'. ... genealogical 5th grade or earn a genealogy diploma. ...
    (soc.genealogy.computing)
  • Naming Conventions dot net/csharp
    ... also always seem to run into conflicting convensions both in code samples ... is that when naming controls, I dont seem to find a standard for radiobutton ... Naming standards for everything throughout an Assembly. ...
    (microsoft.public.dotnet.languages.csharp)