ODBC reserved words
The following words are reserved for use in ODBC function calls. To ensure compatibility with drivers that support the core SQL grammar, you should avoid using any of these keywords in column or table names. If you do use a reserved word, you must enclose it in double quotes.
ADD |
DELETE |
LENGTH |
SET |
ALL |
DESC |
LIKE |
SKIP |
ALTER |
DISTINCT |
LOCATE |
SMALLINT |
AND |
DOUBLE |
LTRIM |
SQRT |
ANY |
DROP |
MAX |
SUBSTR |
AS |
DUMP |
MIN |
SUBSTRING |
ASC |
ELSE |
NCHAR |
SUM |
ASCII |
END |
NOT |
SYNONYM |
AVG |
ESCAPE |
NOW |
SYSDATE |
BETWEEN |
EXISTS |
NULL |
TABLE |
BY |
FLOAT |
NUMBER |
THEN |
CASE |
FOR |
NUMERIC |
TIME |
CAST |
FROM |
NVARCHAR |
TIMESTAMP |
CHAR |
FULL |
NVL |
TO |
CHAR_LENGTH |
GRANT |
OF |
TO_CHAR |
CHARACTER |
GREATEST |
OFF |
TO_DATE |
CHARACTER_LENGTH |
GROUP |
ON |
TO_NUMBER |
CHECK |
HAVING |
OPTION |
TOP |
CHR |
HOUR |
OR |
TRANSLATE |
COLUMN |
IDENTIFIED |
ORDER |
TRUNC |
COMMIT |
IFNULL |
OUTER |
TRUNCATE |
CONCAT |
IN |
PASSWORD |
UCASE |
CONNECT |
INDEX |
POSITION |
UNION |
CONVERT |
INITCAP |
PRECISION |
UNIQUE |
COUNT |
INNER |
PRIMARY |
UPDATE |
CREATE |
INSERT |
PRIVILEGES |
USER |
CURDATE |
INSTR |
PROCEDURE |
VALUES |
CURTIME |
INT |
REAL |
VARCHAR |
DATABASE |
INTEGER |
RENAME |
VARYING |
DATE |
INTO |
RESOURCE |
VIEW |
DATETIME |
IS |
REVOKE |
WHEN |
DAYNAME |
JOIN |
RIGHT |
WHERE |
DBA |
KEY |
ROLLBACK |
WITH |
DEC |
LCASE |
ROUND |
WORK |
DECIMAL |
LEAST |
RTRIM |
|
DECODE |
LEFT |
SELECT |