Solved

What sequences of characters can be used in MICROSOFT JET SQL as names of tables and columns.

Posted on 2008-10-22
10
213 Views
Last Modified: 2012-05-05
Please give me a URL of a page where I can find a formal criterion that helps me determine if the string can or cannot be used instead of <<NAME>> placeholders in here:
SELECT <<NAME>> as <<NAME>> FROM <<NAME>> as <<NAME>>

I am talking about MS JET SQL.

Thanks,
--Igor
0
Comment
Question by:midfde
10 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 22780321
Igor,

It really does not have to be hard: use only letters, numbers, and underscores.  Some Experts even eschew
underscores.  Further, avoid reserved words: SELECT, UPDATE, Date, Format, any of the key commands
in SQL or names of functions.

Patrick
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22780323
0
 
LVL 1

Author Comment

by:midfde
ID: 22780476
OK, I know that the following strings CAN be used as object names:
[Select], [My table], [Include?]
I am not sure about a name with the length, say, 500 characters; or about
__table_name__
and so on.
My program has to determine if a string will be later accepted by JET engine. It (the program) just wants to follow a set of "formal" rules to be able to point user to a right direction to meet these rules.
Please try to help me one more time. (The list of key words looks irrelevant to the issue).
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22780537
from the Access window click Help
type specification in the box

click on Access Specifications
0
 
LVL 1

Author Comment

by:midfde
ID: 22780718
Looks closer to what I need. It's at least a document to refer to. But it's not exactly what I am looking for:
Please see the title of my question. It implies more than just max length.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22780826
be more explicit
0
 
LVL 1

Author Comment

by:midfde
ID: 22780993

capricorn1, specifications you are referring to instruct me that max length of the name is 64.
It does not say whether the following sequences of character are valid sql names:
SELECT
      ["How are you doing?" - John asked]
FROM [I am all right. Thanks.]  
ORDER BY [order by]
And I am looking for a document that explicitly states what... see the title of my question.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22781125
from the same help file type naming objects
then select
Guidelines for naming fields, controls, and objects
0
 
LVL 44

Expert Comment

by:GRayL
ID: 22781143
Have a look at http://msdn.microsoft.com/en-us/library/ms189822.aspx for reserved words.  There is such a wide variety of naming conventions it is probably best to Google - MS SQL naming conventions.
0
 
LVL 1

Author Closing Comment

by:midfde
ID: 31508918


Yes, thanks, it is the best answer although it's not exactly what the rules should be. This however is a usual blunder of MS, not of yours, capricorn1.

The rewarded answer is http://office.microsoft.com/en-us/access/HP051867691033.aspx 
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question