Reserved Words

You are looking at an older version of the documentation. The latest version is found here.

Some words are reserved, meaning they cannot be used as table or field names unless they are escaped. To escape a reserved word, enclose it in double quotes ("").

You can check our complete list of reserved words on this page.

A

ADD

ANY

ALL

ALLOCATE

ALTER

AND

ARE

ARRAY

ARRAY_AGG

AS

ASC

ASENSITIVE

ASYMETRIC

ATOMIC

AUTHORIZATION

B

BEGIN

BETWEEN

BIGDECIMAL

BIGINT

BIGINTEGER

BINARY

BLOB

BOTH

BREA

BY

BYTE

C

CALL

CALLED

CASE

CAST

CASCADED

CHAR

CHARACTER

CHECK

CLOB

CLOSE

COLLATE

COLUMN

COMMIT

CONNECT

CONVERT

CONSTRAINT

CONTINUE

CORRESPONDING

CREATE

CRITERIA

CROSS

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

CYCLE

D

DATALINK

DATE

DAY

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DELETE

DEREF

DESC

DESCRIBE

DETERMINISTIC

DISCONNECT

DISTINCT

DLNEWCOPY

DLPREVIOUSCOPY

DLURLCOMPLETE

DLURLCOMPLETEWRITE

DLURLCOMPLETEONLY 

DLURLPATH

DLURLPATHWRITE

DLURLPATHONLY 

DLURLSCHEME

DLURLSERVER

DLVALUE

DOUBLE

DROP

DYNAMIC

E

EACH

ELEMENT

ELSE

END

ERROR

ESCAPE

EXCEPT

EXEC

EXECUTE

EXISTS

EXTERNAL

F

FALSE

FETCH

FILTER

FLOAT

FOR

FOREIGN

FREE

FROM

FULL

FUNCTION

G

GET

GLOBAL

GRANT

GROUP

GROUPING

H

HAS

HAVING

HOLD

HOUR

I

IDENTITY

INDICATOR

IF

IMMEDIATE

IMPORT

IN

INOUT

INNER

INPUT

INSENSITIVE

INSERT

INTEGER

INTERSECT

INTERVAL

INT

INTO

IS

ISOLATION

J

JOIN

L

LANGUAGE

LARGE

LATERAL

LEADING

LEAVE

LEFT

LIKE

LIKE_REGEX

LIMIT

LOCAL

LOCALTIME

LOCALTIMESTAMP

LONG

LOOP

M

MAKEDEP

MAKENOTDEP

MATCH

MEMBER

MERGE

METHOD

MINUTE

MODIFIES

MODULE

MONTH

MULTISET

N

NATIONAL

NATURAL

NCHAR

NCLOB

NEW 

NO

NOCACHE

NONE

NOT

NULL

NUMERIC

O

OBJECT

OF

OFFSET

OLD

ON

ONLY

OPEN

OR 

ORDER

OUT 

OUTER

OUTPUT

OPTION

OPTIONS

OVER

OVERLAPS

P

PARAMETER

PARTITION

PRECISION

PREPARE

PRIMARY

PROCEDURE

R

RANGE

READS

REAL

RECURSIVE

REFERENCES

REFERENCING

RELEASE

RETURN

RETURNS

REVOKE

RIGHT

ROLLBACK

ROLLUP

ROW

ROWS

S

SAVEPOINT

SCROLL

SEARCH

SECOND

SELECT

SENSITIVE

SESSION_USER

SET

SHORT

SIMILAR

SMALLINT

SOME

SPECIFIC

SPECIFICTYPE

SQL

SQLEXCEPTION

SQLSTATE

SQLWARNING

SUBMULTILIST

START

STATIC

SHOW

STRING

SYMETRIC

SYSTEM

SYSTEM_USER

T

TABLE

TEMPORARY

THEN

TIME

TIMESTAMP

TIMEZONE_HOUR

TIMEZONE_MINUTE

TO

TREAT

TRAILING

TRANSLATE

TRANSLATION

TRIGGER

TRUE

U

UNION

UNIQUE

UNKNOWN

UPDATE

USER

USING

V

VALUE

VALUES

VARCHAR 

VARYING

VIRTUAL

W

WHEN

WHENEVER

WHERE

WHILE

WINDOW

WITH

WITHIN

WITHOUT

X

XML

XMLAGG

XMLATTRIBUTES

XMLBINARY

XMLCAST

XMLCOMMENT

XMLCONCAT

XMLDOCUMENT

XMLELEMENT

XMLEXISTS

XMLFOREST

XMLITERATE

XMLNAMESPACES

XMLPARSE

XMLPI

XMLQUERY

XMLSERIALIZE

XMLTABLE

XMLTEXT

XMLVALIDATE

Y

YEAR