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