Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Naming Conventions?

Re: Naming Conventions?

From: Karen Hill <karen_hill22_at_yahoo.com>
Date: 23 Apr 2007 15:22:53 -0700
Message-ID: <1177366973.050723.192840@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 Mon Apr 23 2007 - 17:22:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US