SQL colum names conventions!
Date: 30 Jul 2006 10:39:38 -0700
As a result of ambiguity problems with colum names when performing a join I discovered that MS SQLServer does not return the conventional tablename.columname but only columname, which of course creates problems.
I have read quite a lot on the subject and some people claim that a colum name should be UNIQUE in a database, i.e. rather than having
the design should be
This would solve ANY ambiguity as to colum names especially in joins.
What is your opinion on that?
P.S. Classis DB / SQL literature does not mention this as a prerequisite for proper DB design.
Adam Received on Sun Jul 30 2006 - 19:39:38 CEST