Table and Column naming conventions

[charles leviton]

Hi all,
Just trying to get a feel here. THe shop I work at insists on
prefixing all column names with the table name, so it is order_id in
the ORDER table and Customer_id in the CUSTOMER table.

I find this irksome and much prefer that a coding standard be imposed
whereby any column name has to be qualified by the table name. So it
would be
SELECT ORDER01.ID
FROM ORDER ORDER01 etc

Of course in the case of foreign keys you would have to judiciously
apply the table name, so if you had a SALES_ITEM table that resolves
the m-n between SALE and ITEM then the 2 foreign keys would be
FK_ITEM_ID and FK_SALE_ID.

What is the general feeling about this?

PS Before someone hollers I did post this on mvshelp.com as well ;-)

[Mark A]

"charles leviton" <ch***********@yahoo.com> wrote in message

Hi all,
Just trying to get a feel here. THe shop I work at insists on
prefixing all column names with the table name, so it is order_id in
the ORDER table and Customer_id in the CUSTOMER table.

I find this irksome and much prefer that a coding standard be imposed
whereby any column name has to be qualified by the table name. So it
would be
SELECT ORDER01.ID
FROM ORDER ORDER01 etc

Of course in the case of foreign keys you would have to judiciously
apply the table name, so if you had a SALES_ITEM table that resolves
the m-n between SALE and ITEM then the 2 foreign keys would be
FK_ITEM_ID and FK_SALE_ID.

What is the general feeling about this?

PS Before someone hollers I did post this on mvshelp.com as well ;-)

You are correct and they are wrong. But they probably do that so they don't
have to modify the declgen COBOL working storage layouts that need unique
names.

[charles leviton]

"Mark A" <[e-mail]> wrote in message news:<l6*****************@news.uswest.net>...

You are correct and they are wrong. But they probably do that so they don't
have to modify the declgen COBOL working storage layouts that need unique
names.

Hey,
Thanks man! Of course seeing as it is the DBAs involved, it is a
losing battle but gratifying to know that someone agrees with me;-)