From: paul@see.my.sig.com   
      
   "Charlie" wrote:   
      
   > Is there a resource for database field naming conventions?   
      
      
   Avoid at all costs using reserved words (either in your target db or   
   others that you may know about). Some dbs allow you to do this by   
   quoting or other mechanisms. Avoid like the plague.   
      
      
   There is of course the underscore versus capitalisation debate - I   
   prefer underscores - SQL standard is not case sensitive.   
      
      
   Paul...   
      
      
   > Jerry   
      
      
   --   
      
   plinehan __at__ yahoo __dot__ __com__   
      
   XP Pro, SP 2,   
      
   Oracle, 10.2.0.1 (Express Edition)   
   Interbase 6.0.2.0;   
      
   When asking database related questions, please give other posters   
   some clues, like operating system, version of db being used and DDL.   
   The exact text and/or number of error messages is useful (!= "it didn't   
   work!").   
   Thanks.   
      
   Furthermore, as a courtesy to those who spend   
   time analysing and attempting to help, please   
   do not top post.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|