SQL colum names conventions!
From: <mail_at_jazzis.com>
Date: 30 Jul 2006 10:39:38 -0700
Message-ID: <1154281178.154931.48170_at_s13g2000cwa.googlegroups.com>
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.
Date: 30 Jul 2006 10:39:38 -0700
Message-ID: <1154281178.154931.48170_at_s13g2000cwa.googlegroups.com>
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
table1.column
table2.column
the design should be
table1.colum1
table2.colum2
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