Revolving around the core of technology
| Document ID: | 812 |
|---|---|
| Subject: | Quering tables with spaces in their names |
| Creation date: | 7/29/09 4:44 PM |
| Last modified on: | 12/11/18 3:36 PM |
Often designers choose to put spaces within the table or field name. Every database treats this scenario differently. Some databases 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.
Posted by Chris on 9/10/13 2:29 PM
Do you have a helpful tip related to this document that you'd like to share with other users?