Reserved Words

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