While not being within the mandated SQL core, these keywords should be avoided in applications to preserve compatibility with SQL99-compliant drivers.
ODBC 3.0 reserved keywords:
|
ABSOLUTE |
BOTH |
CONSTRAINT |
|
ACTION |
BY |
CONSTRAINTS |
|
ADA |
CASCADE |
CONTINUE |
|
ADD |
CASCADED |
CONVERT |
|
ALL |
CASE |
CORRESPONDING |
|
ALLOCATE |
CAST |
COUNT |
|
ALTER |
CATALOG |
CREATE |
|
AND |
CHAR |
CROSS |
|
ANY |
CHAR_LENGTH |
CURRENT |
|
ARE |
CHARACTER |
CURRENT_DATE |
|
AS |
CHARACTER_LENGTH |
CURRENT_TIME |
|
ASC |
CHECK |
CURRENT_TIMESTAMP |
|
ASSERTION |
CLOSE |
CURRENT_USER |
|
AT |
COALESCE |
CURSOR |
|
AUTHORIZATION |
COLLATE |
DATE |
|
AVG |
COLLATION |
DAY |
|
BEGIN |
COLUMN |
DEALLOCATE |
|
BETWEEN |
COMMIT |
DEC |
|
BIT |
CONNECT |
DECIMAL |
|
BIT_LENGTH |
CONNECTION |
DECLARE |
|
DEFAULT |
FOUND |
LANGUAGE |
|
DEFERRABLE |
FROM |
LAST |
|
DEFERRED |
FULL |
LEADING |
|
DELETE |
GET |
LEFT |
|
DESC |
GLOBAL |
LEVEL |
|
DESCRIBE |
GO |
LIKE |
|
DESCRIPTOR |
GOTO |
LOCAL |
|
DIAGNOSTICS |
GRANT |
LOWER |
|
DISCONNECT |
GROUP |
MATCH |
|
DISTINCT |
HAVING |
MAX |
|
DOMAIN |
HOUR |
MIN |
|
DOUBLE |
IDENTITY |
MINUTE |
|
DROP |
IMMEDIATE |
MODULE |
|
ELSE |
IN |
MONTH |
|
END |
INCLUDE |
NAMES |
|
END-EXEC |
INDEX |
NATIONAL |
|
ESCAPE |
INDICATOR |
NATURAL |
|
EXCEPT |
INITIALLY |
NCHAR |
|
EXCEPTION |
INNER |
NEXT |
|
EXEC |
INPUT |
NO |
|
EXECUTE |
INSENSITIVE |
NONE |
|
EXISTS |
INSERT |
NOT |
|
EXTERNAL |
INT |
NULL |
|
EXTRACT |
INTEGER |
NULLIF |
|
FALSE |
INTERSECT |
NUMERIC |
|
FETCH |
INTERVAL |
OCTET_LENGTH |
|
FIRST |
INTO |
OF |
|
FLOAT |
IS |
ON |
|
FOR |
ISOLATION |
ONLY |
|
FOREIGN |
JOIN |
OPEN |
|
FORTRAN |
KEY |
OPTION |
|
OR |
SECOND |
TRANSACTION |
|
ORDER |
SECTION |
TRANSLATE |
|
OUTER |
SELECT |
TRANSLATION |
|
OUTPUT |
SESSION |
TRIM |
|
OVERLAPS |
SESSION_USER |
TRUE |
|
PAD |
SET |
UNION |
|
PARTIAL |
SIZE |
UNIQUE |
|
PASCAL |
SMALLINT |
UNKNOWN |
|
POSITION |
SOME |
UPDATE |
|
PRECISION |
SPACE |
UPPER |
|
PREPARE |
SQL |
USAGE |
|
PRESERVE |
SQLCA |
USER |
|
PRIMARY |
SQLCODE |
USING |
|
PRIOR |
SQLERROR |
VALUE |
|
PRIVILEGES |
SQLSTATE |
VALUES |
|
PROCEDURE |
SQLWARNING |
VARCHAR |
|
PUBLIC |
SUBSTRING |
VARYING |
|
READ |
SUM |
VIEW |
|
REAL |
SYSTEM_USER |
WHEN |
|
REFERENCES |
TABLE |
WHENEVER |
|
RELATIVE |
TEMPORARY |
WHERE |
|
RESTRICT |
THEN |
WITH |
|
REVOKE |
TIME |
WORK |
|
RIGHT |
TIMESTAMP |
WRITE |
|
ROLLBACK |
TIMEZONE_HOUR |
YEAR |
|
ROWS |
TIMEZONE_MINUTE |
ZONE |
|
SCHEMA |
TO | |
|
SCROLL |
TRAILING |