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
);

Who considers hungarian notation bad? And why?

aside:
Does anybody remember when the hungarian space program gets off the ground? Is that this year or next?
/aside

SQL has too many standards. Camel case to separate words doesn't make a whole lot of sense for case insensitive names.

From a theoretical standpoint, names are rather unimportant. Naming conventions are all about applied human psychology and are more closely related to information architecture than database theory.
.

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: Naming Conventions?
    ... So there are no standards in SQL for naming? ... there are hungarian notation, Camel Case, Pascal ... colPrimaryKey INT PRIMARY KEY ...
    (comp.databases.theory)
  • Re: Naming Conventions?
    ... So there are no standards in SQL for naming? ... there are hungarian notation, Camel Case, Pascal ... has all the customer data should be called Customers, ... CamelCase looks pretty good to me, but that's just personal taste. ...
    (comp.databases.theory)
  • Re: Naming Conventions?
    ... So there are no standards in SQL for naming? ... In programming languages ... there are hungarian notation, Camel Case, Pascal ...
    (comp.databases.theory)
  • [OT] Re: Why is Hungarian Notation Considered Evil?
    ... > I've heard in quite a few places that Hungarian Notation is bad ... > there are other reasons, ... The third wart is that I don't like it!-) ... try reading MS C source code:( ...
    (comp.object)