FrontBase Documentation

Backtrack:
  Welcome!
    5. SQL 92
      5.1. SQL 92 Primer
Updated: 20-Nov-2000
prev — next
Table of Contents

5.1.6. Keywords

SQL 92 has a very extensive set of keywords and you may run into some surprises when selecting the spelling for an identifier of yours. It may very well collide with the spelling of an SQL 92 keyword. Please also note that an identifier cannot begin with an underscore.
There are a couple of ways to reduce the "collision" problems. There is no keyword in SQL 92 ending with an underscore, e.g. it is legal to use SELECT_ as an identifier.
By enclosing the identifier in double quotes, essentially any spelling can be used as an identifier, e.g. "SELECT" is a legal identifier.
SQL 92 is case insensitive, e.g. Movies as an identifier is considered identical to MOVIES.

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!