ODBC reserved words
Do not use the reserved words listed here (taken from the SQL grammar in Appendix C of the Microsoft ODBC Programmer’s Reference) as identifiers (that is, table or column names), unless you surround the word in double quotation marks (for example, "DATE" or "DESC"). Many ODBC aware products will do this for you. Lotus 123 Release 4 is a notable exception.
ABS | ABSOLUTE | ACTION | ADA |
ADD | ALIAS | ALL | ALLOCATE |
ALTER | AND | ANY | ARE |
AS | ASC | ASCII | ASSERTION |
AT | ATAN | AUTHORIZATION | AUTO |
AVG | BCDDATE | BEGIN | BETWEEN |
BIT | BIT_LENGTH | BLOB | BLOCKLEN |
BOTH | BY | CASCADE | CASCADED |
CASE | CAST | CATALOG | CATALOGUE |
CBLOB | CEILING | CHAR | CHARACTER |
CHARACTER_LENGTH | CHAR_LENGTH | CHECK | CLOSE |
COALESCE | COBOL | COLLATE | COLLATION |
COLUMN | COMMIT | CONCAT | CONNECT |
CONNECTION | CONSTRAINT | CONSTRAINTS | CONTINUE |
CONVERT | CORRESPONDING | COS | COUNT |
CREATE | CROSS | CURDATE | CURRENT |
CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER |
CURSOR | DATABASE | DATE | DATESTAMP |
DAY | DAYNAME | DAYOFMONTH | DAYOFWEEK |
DAYOFYEAR | DBCSEND | DBCSSTART | DEALLOCATE |
DEC | DECIMAL | DECLARE | DEFAULT |
DEFERRABLE | DEFERRED | DELETE | DESC |
DESCRIBE | DESCRIPTION | DESCRIPTOR | DIAGNOSTICS |
DIFFERENCE | DISCONNECT | DISPLAY | DISTINCT |
DOMAIN | DOUBLE | DROP | DTD |
ELSE | END | END-EXEC | ESCAPE |
EXCEPT | EXCEPTION | EXCLUDE | EXEC |
EXECUTE | EXISTS | EXP | EXPLICIT |
EXTENT | EXTERNAL | EXTRACT | FALSE |
FETCH | FIRST | FLAT | FLOAT |
FLOOR | FOR | FOREIGN | FORTRAN |
FOUND | FROM | FULL | GET |
GLOBAL | GO | GOTO | GRANT |
GROUP | HAVING | HEX | HOUR |
IBMPACKED | IDENTITY | IFNULL | IMMEDIATE |
IN | INCLUDE | INDEX | INDICATOR |
INITIALLY | INNER | INPUT | INSENSITIVE |
INSERT | INTEGER | INTERNAL_NUMBER | INTERSECT |
INTERVAL | INTO | IPREFIX | IS |
ISOLATION | JOIN | KDB | KEY |
LANGUAGE | LAST | LCASE | LEADING |
LEFT | LENGTH | LEVEL | LIKE |
LOCAL | LOCATE | LOG | LONGUSERNAMES |
LOWER | LTRIM | MATCH | MAX |
MIN | MINUTE | MOD | MODIFY |
MODULE | MONTH | MONTHNAME | MUMPS |
NAME | NAMES | NATIONAL | NATURAL |
NCHAR | NEXT | NO | NOCOMPACT |
NOEDIT | NOISE | NONALPHA | NONE |
NOT | NOW | NULL | NULLIF |
NUMERIC | OCCURS | OCTET_LENGTH | OF |
OFFSET | OLD_DATE | ON | ONLY |
OPEN | OPTION | OR | ORDER |
OUTER | OUTPUT | OVERLAPS | PACKING |
PAD | PARTIAL | PASCAL | PATH |
PERMISSIONS | PLI | POSITION | POSTVAL |
PRECISION | PREPARE | PRESERVE | PREVAL |
PRIMARY | PRIOR | PRIORITY | PRIVILEGES |
PROCEDURE | PUBLIC | QUARTER | RAND |
RANGE | RAW | RECLEN | REFERENCES |
RELATIVE | RENAME | REPEAT | RESTRICT |
REVOKE | RIGHT | ROLLBACK | ROWS |
RTRIM | SCHEMA | SCROLL | SECOND |
SECTION | SELECT | SEQUENCE | SERIAL |
SESSION | SESSION_USER | SET | SIGN |
SIGNED | SIN | SIZE | SMALLINT |
SOME | SORTMERGE | SOUNDEX | SPACE |
SPECIAL | SQL | SQL_TSI_DAY | SQL_TSI_MONTH |
SQL_TSI_QUARTER | SQL_TSI_WEEK | SQL_TSI_YEAR | SQLCA |
SQLCODE | SQLERROR | SQLSTATE | SQLWARNING |
SQRT | STARTBYTE | SUBSTRING | SUM |
SYSTEM_USER | TABLE | TABLESPACE | TAN |
TEMPORARY | THEN | TIME | TIMESTAMP |
TIMESTAMPADD | TIMESTAMPDIFF | TIMEZONE_HOUR | TIMEZONE_MINUTE |
TO | TOP | TOTALLED | TRAILING |
TRANSACTION | TRANSLATE | TRANSLATION | TREE |
TRIM | TRUE | TYPE | UCASE |
UNION | UNIQUE | UNKNOWN | UNSIGNED |
UPDATE | UPPER | USAGE | USER |
USERSTAMP | USING | VALIDATE | VALUE |
VALUES | VARCHAR | VARYING | VENDOR(MICROSOFT),PRODUCT(ODBC) |
VIEW | VIRTUAL | WEEK | WHEN |
WHENEVER | WHERE | WITH | WORD |
WORK | XML | XMLDATA | YEAR |
YES |