SQL Reserved Words

This section lists all the Derby reserved words, including those in the SQL-92 standard. Derby will return an error if you use any of these keywords as an identifier name unless you surround the identifier name with quotes ("). See Rules for SQL92Identifiers.

ADD

ALL

ALLOCATE

ALTER

AND

ANY

ARE

AS

ASC

ASSERTION

AT

AUTHORIZATION

AVG

BEGIN

BETWEEN

BIT

BIT_LENGTH

BOOLEAN

BOTH

BY

CALL

CASCADE

CASCADED

CASE

CAST

CHAR

CHARACTER

CHARACTER_LENGTH

CHAR_LENGTH

CHECK

CLOSE

COLLATE

COLLATION

COLUMN

COMMIT

CONNECT

CONNECTION

CONSTRAINT

CONSTRAINTS

CONTINUE

CONVERT

CORRESPONDING

COUNT

CREATE

CROSS

CURRENT

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFERRABLE

DEFERRED

DELETE

DESC

DESCRIBE

DIAGNOSTICS

DISCONNECT

DISTINCT

DOUBLE

DROP

ELSE

END

ENDEXEC

ESCAPE

EXCEPT

EXCEPTION

EXEC

EXECUTE

EXISTS

EXPLAIN

EXTERNAL

EXTRACT

FALSE

FETCH

FIRST

FLOAT

FOR

FOREIGN

FOUND

FROM

FULL

FUNCTION

GET

GET_CURRENT_CONNECTION

GLOBAL

GO

GOTO

GRANT

GROUP

HAVING

HOUR

IDENTITY

IMMEDIATE

IN

INDICATOR

INITIALLY

INNER

INOUT

INPUT

INSENSITIVE

INSERT

INT

INTEGER

INTERSECT

INTO

IS

ISOLATION

JOIN

KEY

LAST

LEADING

LEFT

LIKE

LOCAL

LONGINT

LOWER

LTRIM

MATCH

MAX

MIN

MINUTE

NATIONAL

NATURAL

NCHAR

NVARCHAR

NEXT

NO

NOT

NULL

NULLIF

NUMERIC

OCTET_LENGTH

OF

ON

ONLY

OPEN

OPTION

OR

ORDER

OUT

OUTER

OUTPUT

OVERLAPS

PAD

PARTIAL

PREPARE

PRESERVE

PRIMARY

PRIOR

PRIVILEGES

PROCEDURE

PUBLIC

READ

REAL

REFERENCES

RELATIVE

RESTRICT

REVOKE

RIGHT

ROLLBACK

ROWS

RTRIM

RUNTIMESTATISTICS

SCHEMA

SCROLL

SECOND

SELECT

SESSION_USER

SET

SMALLINT

SOME

SPACE

SQL

SQLCODE

SQLERROR

SQLSTATE

SUBSTR

SUBSTRING

SUM

SYSTEM_USER

TABLE

TEMPORARY

TIMEZONE_HOUR

TIMEZONE_MINUTE

TINYINT

TO

TRAILING

TRANSACTION

TRANSLATE

TRANSLATION

TRIM

TRUE

UNION

UNIQUE

UNKNOWN

UPDATE

UPPER

USER

USING

VALUES

VARCHAR

VARYING

VIEW

WHENEVER

WHERE

WITH

WORK

WRITE

YEAR