Re: Field naming conventions
Date: Sat, 23 Dec 2006 12:45:17 +0000
"Charlie" <jadkins4_at_yahoo.com> wrote:
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.
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 10.2.0.1 (Express Edition) Interbase 220.127.116.11; 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.Received on Sat Dec 23 2006 - 13:45:17 CET