Getting around SQL Reserved Words...

[Mitch_____W]

I had a bad habit of when I named tables, querys, forms, modules, and macros, the last part of the name would be what it was...

For example:

In one database I have about 10 tables and some of the table names are :

Emploee Info Table
Annex Table
License info Table

The same thing for the querys, forms, macros etc...

Now that these names are referenced throughout the database I don't want to go through and change all of them.

The reason for me pondering the name changes is that I was trying to use some SQL, and "TABLE" is a reserved word.

Is there any way I can get around this problem without changing names of almost every object in my database???


Thanks!!!

Mitch

 

[araskas]

Even if 'Table'is a reserved word if you enclose in square brackets it will be treated as object name. For example you could use [Emploee Info Table] . I would say next time you name your tables use something like this - Emploee_Info_Table or in Hungarian notation tblEmpInfo.