Keywords

Keywords have special meaning in SQL and may not be used as identifiers. Although some entries in the following list are not part of the server SQL language dialect, the server SQL Universal Translator treats them as keywords. This is for future expansion and to help diagnose certain kinds of syntax errors.

ALIAS
ALTER
ALL
AND
ANY
AS
ASC
AVG

BETWEEN
BEGIN
BIND
BIT
BOTH
BY

CASE
CHAR
CHARACTER
CHECK
CLOSE
COALESCE
COLFETCH
COMMIT
CONNECT
COUNT
CREATE
CURRENT

DATABASE
DATE
DATETIME
DEC

DECIMAL
DECLARE
DELETE
DESC
DISTINCT
DOUBLE
DROP

ELSEEND
ESCAPE
EXCEPT
EXECUTE
EXISTS

FETCH
FILE
FLOAT
FOR
FROM

GRAPHIC
GROUP

HAVING

IMAGE
IN
INNER
INSERT
INT
INTEGER
INTERSECT INTO
IS

JOIN

KEY

LEADING
LEFT
LIKE
LOGICAL
LONG

MAX
MIN
MONEY

NOT
NULL
NULLIF
NUMBER
NUMERIC

OF
OFF
OPEN
ON
ONLY
OPTION
OR
ORDER
OUTER

PRECISION
PRIMARY

RAW
REAL
REFERENCE
RIGHT
ROLLBACK

SELECT
SERIAL
SET
SMALLFLOAT
SMALLINT
SOME
SQLID
SUM
SYSNAME

TABLE
TEXT
TIME
TIMESTAMP
TIMEZONE
TO

USER
UNION
UNIQUE
USER_TYPE_NAME
USING
UPDATE


iWay Software