This topic lists the Model 204 SQL reserved words, which are words that you cannot use as names of SQL objects.
This list includes standard and emerging standard SQL reserved words and Model 204 SQL proprietary reserved words (in italics).
Model 204 SQL reserved words
ADD
ALL
ALTER
AND
ANY
AS
ASC
AUTHORIZATION
AVG
BEGIN
BETWEEN
BLOB
BY
CASCADE
CAST
CHAR
CHARACTER
CHECK
CLOB
CLOSE
COBOL
COMMIT
CONTINUE
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURSOR
|
DEC
DECIMAL
DECLARE
DEFAULT
DELETE
DESC
DISTINCT
DOUBLE
DROP
END
ESCAPE
EXEC
EXISTS
FETCH
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
FULL
GO
GOTO
GRANT
GROUP
HASH
HAVING
|
IN
INDEX
INDICATOR
INNER
INSERT
INT
INTEGER
INTO
IS
JOIN
KEY
LANGUAGE
LEFT
LIKE
MAX
MIN
MODIFY
MODULE
NATURAL
NESTED
NOT
NULL
NUM
NUMERIC
|
OF
ON
OPEN
OPTION
OR
ORDER
ORDERED
OUTER
PASCAL
PLI
POSITIONED
PRECISION
PRIMARY
PRIVILEGES
PROCEDURE
PUBLIC
REAL
REFERENCES
RESTRICT
REVOKE
RIGHT
ROLLBACK
|
SCHEMA
SECTION
SELECT
SET
SMALLINT
SOME
SORT
SQL
SQLCODE
SQLERROR
SQLSTATE
SQLVERSION
SUM
SYSNAME
SYSTEM
TABLE
TO
TYPE
UNCATALOG
UNION
UNIQUE
UPDATE
USER
USING
|
VALUES
VIEW
WHENEVER
WHERE
WITH
WORK
GE
LE
NE
|