WinSQL » 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: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.

User comments

Posted by Chris on 9/10/13 2:29 PM


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?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by