|
|
Knowledge Base
Document information| Document ID: | 812 |
|---|
| Subject: | Quering tables with spaces in their names |
|---|
| Creation date: | 7/29/09 4:44 PM |
|---|
| Last modified on: | 7/29/09 4:44 PM |
|---|
Details
Often designers choose to put spaces within the table or field
name. Every database treats this scenario differently. Some database
use a double quote to enclose object names while others use a square
bracket.
If you are not sure which character to use, try using any of the built-in wizards in WinSQL. For example, click on the Catalog
tab, open the table contain a space in its name, browse its content and
double click any row. This will invoke the Update wizard in WinSQL. Try
modifying any existing value in the window and watch WinSQL generate
the SQL, which will contain the appropriate character that is used to
enclose objects in the back-end database.
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.
|
