Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 03 Apr 2006 @ 20:11:11 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Column Naming
 
From:   Howard, Jack

Anyone use mixed case / no spaces as their column naming convention? Using a simple column name such as "Message Address ID" implemented as MessageAddressID (mixed case/ no spaces) works as long as mixed case is always preserved. The horror is when the column name is not respected by some other tool/technology and it translates mixed case column names to all upper case (e.g., MESSAGEADDRESSID). Some years ago I did a test and found one vendor in my ex-company's stack that did the dreaded conversion. Although the technology functioned perfectly, the readability was "difficult."

If you are using mixed case column names are you happy with that convention today? My leaning is to mixed case since it conserves space in the column name length. But the upper case display without possibility of parole is a dreadful threat. But, perhaps this issue is now resolved since the vendors have all released several versions since my original analysis?



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016