Re: Naming Conventions?

From: Karen Hill <karen_hill22_at_yahoo.com>
Date: 23 Apr 2007 15:22:53 -0700
Message-ID: <1177366973.050723.192840_at_e65g2000hsc.googlegroups.com>


On Apr 23, 3:15 pm, Bob Badour <bbad..._at_pei.sympatico.ca> 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
); Received on Tue Apr 24 2007 - 00:22:53 CEST

Original text of this message