keyword "NAME" not reserved keyword 
Author Message
 keyword "NAME" not reserved keyword

Although "Name" is not listed in the list of reserved keywords in BOL it
does turn blue in query analyzer indicating that it is a keyword.  I was
able to find where it is used in string functions such as <<dimension>>.Name
but that is all.  I know that it is not recommended to use keywords as a
column name on a table but I need more concrete reasons as to why not to
prove my case.  Can anyone give me more reasons?  You can actually run a
query "Select name from MyTable" and not get an error which is the argument
I get from developers.


Thu, 19 Feb 2004 00:21:56 GMT
 keyword "NAME" not reserved keyword

If there was a universal property, then Name would be it. there isn't
an object in all of programming that doesn't have a Name property.
What more reason do you need? The fact that it works in T-SQL doesn't
mean it's a good idea to use it as a column name. It may not break in
T-SQL, but it's bound to cause problems elsewhere.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

Quote:

>Although "Name" is not listed in the list of reserved keywords in BOL it
>does turn blue in query analyzer indicating that it is a keyword.  I was
>able to find where it is used in string functions such as <<dimension>>.Name
>but that is all.  I know that it is not recommended to use keywords as a
>column name on a table but I need more concrete reasons as to why not to
>prove my case.  Can anyone give me more reasons?  You can actually run a
>query "Select name from MyTable" and not get an error which is the argument
>I get from developers.



Thu, 19 Feb 2004 01:58:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Keyword "identitycol" problem

2. "Keywords"

3. Type Library - Problems with "Implements" Keyword

4. NewB question "Like" keyword

5. "Primary" keyword in Primary Key declaration

6. Uncertain about usage of "Nothing" keyword

7. First keyword in Access any comparable keyword in SQLServer

8. Using the 'IN" keyword

9. Where are the Reserved Keywords defined?

10. Replication Server / Sybase 10 / reserved keywords

11. Ingres Reserved Words (Keywords)


 
Powered by phpBB® Forum Software