Re: Suggestions for naming conventions

hi,

xmark.powell_at_eds.com.x wrote:
>
> Column names:
> 3) Do not prefix the column names with a table name abbreviation.
> This is unnecessary as columns can/will be identified in the SQL
> with table name
> lables
>
> SQL:
> 2) Label every table_name in the from clause of a join and prefix
> every column name occurrance in the SQL with the label
>

if you prefix every column of a table you don't have to think about meaningfull labels when you are writing a statement and the 'table labels' are all the same in the different statements of your developers.
(columns of the ACCOUNT table begin with ACC_ and not with A. or T5. or QWER. or ...)

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de