Quote:
Originally posted by tamilselvan
You guys poorly understood.
First of all I did not say every column should be started with the TABLE name. For example, the table name could be ACCOUNTS, the column name can be ACCNT_END_DATE, ACCNT_START_DATE.
It is always better to use abbreviation, if the length of the subject is too long. Some examples are CUST for CUSTOMER, ACCNT for ACCOUNTS etc.
So now we have column name prefixes that are actually different than the table name they are in? I would vote for consistency in this case. Either both the table name and prefix should be abbreviated or neither.