SQL common reserved words

The SQL language is composed of reserved words, that is, special words that run SQL operations.

Restriction: Do not use these reserved words when you name databases, tables, columns, or any other database objects.

The following table contains a list of the common reserved words.

ABORT

EXISTS

ONLINE

ALL

EXPLAIN

ONLY

ALLOCATE

EXPRESS

ANALYSE

EXTEND

ORDER

ANALYZE

EXTERNAL

OTHERS

AND

EXTRACT

OUT

ANY

FALSE

OUTER

FIRST

OVER

ASC

FLOAT

OVERLAPS

AUTOMAINT

FOLLOWING

PARTITION

AWSS3

FOR

PAUSESTEPS

AZUREBLOB

FOREIGN

PAUSETIME

BETWEEN

FROM

POSITION

BINARY

FULL

PRECEDING

BIT

FUNCTION

PRECISION

BOTH

GENSTATS

PRESERVE

CASE

GLOBAL

PRIMARY

CAST

GROUP

CHAR

HAVING

RESET

CHARACTER

HISTOGRAM

REUSE

CHECK

IDENTIFIER_CASE

RIGHT

CLUSTER

ILIKE

ROWS

COALESCE

SELECT

COLLATE

INDEX

SESSION_USER

COLLATION

INITIALLY

SETOF

COLUMN

INNER

SHOW

CONSTRAINT

INOUT

SOME

COPY

INTERSECT

TABLE

CROSS

INTERVAL

TEMPORAL

CURRENT

INTO

THEN

CURRENT_CATALOG

JOURNAL

TIES

CURRENT_DATE

LEADING

TIME_TRAVEL_ENABLE

CURRENT_DB

LEFT

TIME

CURRENT_SCHEMA

TIMESTAMP

CURRENT_SID

LIMIT

CURRENT_TIME

LOAD

TRAILING

CURRENT_TIMESTAMP

LOCAL

TRANSACTION

CURRENT_USER

LOCK

TRIGGER

CURRENT_USERID

MINUS

TRIM

CURRENT_USEROID

MOVE

TRUE

DAYSPERROW

NATURAL

UNBOUNDED

DEALLOCATE

NCHAR

UNION

DEC

NEW

UNIQUE

DECIMAL

NOCASCADE

USER

DECODE

NOT

USING

DEFAULT

NOTNULL

VACUUM

DEREGISTER

NULL

VARCHAR

DESC

NULLS

VERBOSE

DISTINCT

NUMERIC

VERSION

DISTRIBUTE

NVL

VIEW

NVL2

UNBOUNDED

ELSE

OFF

UNION

END

OFFSET

UNIQUE

EXCEPT

OLD

USER

EXCLUDE

In addition, Netezza Performance Server SQL considers the following system attributes reserved words:

CTID
OID
XMIN
CMIN
XMAX
CMAX
TABLEOID
ROWID
DATASLICEID
CREATEXID
DELETEXID