Re: Naming Convention for Columns

Just continuing the thread.

Why not give the columns meaningful names, and where two or more tables hold the same data values use the same column name. There is no need to include the table name as part of the column name. I have yet to meet and end-customer who can not grasp the consept of assigning a label to a table name and joining liked named columns as in 'e.deptno = d.deptno'.

The original driving force behind Dr. Codd creating relational database theory was that rows and columns are easy for end-users to understand.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Mar 17 1998 - 00:00:00 CET