5. SQL 92
5.1. SQL 92 Primer
Table of Contents
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.
Moviesas an identifier is considered identical to
If you have feedback or questions on this document, please send e-mail to email@example.com. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.