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




User comments

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

In MS SQL SELECT * FROM [My Table]


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.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com