VERIFIED SOLUTION i

How to find a list of SQL reserved words

Product affected: MapInfo Professional™
 
User's of MapInfo Professional frequently need to make connections to databases and run queries using SQL.
Here is a list of reserved SQL words.

This list of Microsoft® (MS) Access® and T-SQL® Reserved and delimited words has extracted from Microsoft.com and is provided here as a quick reference. MS Access and MS SQLserver are the most frequently used databases in ColdFusion applications. In the future we will add reserved words from other database systems.
The use of a Reserved Word in a SQL Query as a variable can cause ODBC and other unexpected ColdFusion and application errors.
The following list includes all words reserved by the Microsoft Jet database engine for use in SQL statements. The words in the list that are not in all uppercase letters are also reserved by other applications. Consequently, the individual Help topics for these words provide general descriptions that don't focus on SQL usage.
Note Words followed by an asterisk (*) are reserved but currently have no meaning in the context of a Microsoft Jet SQL statement (for example, Level and TableID).
A - C
ADD
ALL
Alphanumeric — See TEXT
ALTER
And
ANY
AS
ASC
AUTOINCREMENT — See COUNTER
Avg
Between
BINARY
BIT
BOOLEAN — See BIT
BY
BYTE
CHAR, CHARACTER — See TEXT
COLUMN
CONSTRAINT
Count
COUNTER
CREATE
CURRENCY
 
D - H
DATABASE
DATE — See DATETIME
DATETIME
DELETE
DESC
DISALLOW
DISTINCT
DISTINCTROW
DOUBLE
DROP
Eqv
EXISTS
FLOAT, FLOAT8 — See DOUBLE
FLOAT4 — See SINGLE
FOREIGN
FROM
GENERAL — See LONGBINARY
GROUP
GUID
HAVING
 
I - L
IEEEDOUBLE — See DOUBLE
IEEESINGLE — See SINGLE
IGNORE
Imp
In
IN
INDEX
INNER
INSERT
INT, INTEGER, INTEGER4 — See LONG
INTEGER1 — See BYTE
INTEGER2 — See SHORT
INTO
Is
JOIN
KEY
LEFT
Level*
Like
LOGICAL, LOGICAL1 — See BIT
LONG
LONGBINARY
LONGTEXT
 
M - R
Max
MEMO — See LONGTEXT
Min
Mod
MONEY — See CURRENCY
Not
NULL
NUMBER — See DOUBLE
NUMERIC — See DOUBLE
OLEOBJECT — See LONGBINARY
On
OPTION
Or
ORDER
Outer*
OWNERACCESS
PARAMETERS
PERCENT
PIVOT
PRIMARY
PROCEDURE
REAL — See SINGLE
REFERENCES
RIGHT
 
S - Z
SELECT
SET
SHORT
SINGLE
SMALLINT — See SHORT
SOME
StDev
StDevP
STRING — See TEXT
Sum
TABLE
TableID*
TEXT
TIME — See DATETIME
TIMESTAMP — See DATETIME
TOP
TRANSFORM
UNION
UNIQUE
UPDATE
VALUE
VALUES
Var
VARBINARY — See BINARY
VARCHAR — See TEXT
VarP
WHERE
WITH
Xor
YESNO — See BIT
 
 
UPDATED:  August 12, 2019