Thursday, February 16, 2012

Characters not to use in Table and Field Names: your opinion/experiences

Hi,
I know we can use several non-alpha characters in the names of Tables and
Fields, but I still think it's not a good rpactice. The same thing with the
spaces etc, which can be used, but tiwh the brackets []. Microsoft even uses
underscore_ in their own tables, but still I don't like it because I guess
it could mess up when using the _ for a wildcard.
So I actually prefer not to use Table and field names with special
(non-alpha) characters. Reserved words aren't done either!
And what about figures? I can't really find an exemple wheir it could harm
something, but I don't like it either. Can anybody give me some more info
about this? And any idea about non-alpha characters that can be used safely?
All this not only taking in my Sql Server itself, but also programming
languages that use these databases (especially .NET).
PieterMy personal preference is to have purely alphabetical table and column
names. For example, ProductID is much more preferable than Product_ID or
[Product-ID] or [Product ID]
Not having these non-alphabetic and special characters in the names makes it
much easier to type things when I am busily troubleshooting something for
example.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:%23Jsbr6$lFHA.572@.TK2MSFTNGP15.phx.gbl...
Hi,
I know we can use several non-alpha characters in the names of Tables and
Fields, but I still think it's not a good rpactice. The same thing with the
spaces etc, which can be used, but tiwh the brackets []. Microsoft even uses
underscore_ in their own tables, but still I don't like it because I guess
it could mess up when using the _ for a wildcard.
So I actually prefer not to use Table and field names with special
(non-alpha) characters. Reserved words aren't done either!
And what about figures? I can't really find an exemple wheir it could harm
something, but I don't like it either. Can anybody give me some more info
about this? And any idea about non-alpha characters that can be used safely?
All this not only taking in my Sql Server itself, but also programming
languages that use these databases (especially .NET).
Pieter

No comments:

Post a Comment