Restricted KeywordsΒΆ

The following Keywords are restricted in JSQLParser-4.8 and must not be used for Naming Objects:

Keyword

JSQL Parser

SQL:2016

ABSENT

Yes

Yes

ALL

Yes

Yes

AND

Yes

Yes

ANY

Yes

Yes

AS

Yes

Yes

BETWEEN

Yes

Yes

BOTH

Yes

Yes

CASEWHEN

Yes

CHECK

Yes

Yes

CONNECT

Yes

CONNECT_BY_ROOT

Yes

Yes

CONSTRAINT

Yes

Yes

CREATE

Yes

CROSS

Yes

Yes

CURRENT

Yes

Yes

DISTINCT

Yes

Yes

DOUBLE

Yes

ELSE

Yes

Yes

EXCEPT

Yes

Yes

EXISTS

Yes

Yes

FETCH

Yes

Yes

FINAL

Yes

Yes

FOR

Yes

Yes

FORCE

Yes

Yes

FOREIGN

Yes

Yes

FROM

Yes

Yes

FULL

Yes

Yes

GLOBAL

Yes

GROUP

Yes

Yes

GROUPING

Yes

QUALIFY

Yes

HAVING

Yes

Yes

IF

Yes

Yes

IIF

Yes

IGNORE

Yes

ILIKE

Yes

Yes

IN

Yes

Yes

INNER

Yes

Yes

INTERSECT

Yes

Yes

INTERVAL

Yes

Yes

INTO

Yes

Yes

IS

Yes

Yes

JOIN

Yes

Yes

LATERAL

Yes

Yes

LEFT

Yes

Yes

LIKE

Yes

Yes

LIMIT

Yes

Yes

MINUS

Yes

Yes

NATURAL

Yes

Yes

NOCYCLE

Yes

Yes

NOT

Yes

Yes

NULL

Yes

Yes

OFFSET

Yes

Yes

ON

Yes

Yes

ONLY

Yes

Yes

OPTIMIZE

Yes

OR

Yes

Yes

ORDER

Yes

Yes

OUTER

Yes

Yes

OUTPUT

Yes

Yes

OPTIMIZE

Yes

Yes

PIVOT

Yes

Yes

PROCEDURE

Yes

PUBLIC

Yes

RECURSIVE

Yes

Yes

REGEXP

Yes

Yes

RETURNING

Yes

Yes

RIGHT

Yes

Yes

SAMPLE

Yes

SEL

Yes

SELECT

Yes

SEMI

Yes

Yes

SET

Yes

Yes

SOME

Yes

Yes

START

Yes

Yes

TABLES

Yes

TOP

Yes

Yes

TRAILING

Yes

Yes

UNBOUNDED

Yes

Yes

UNION

Yes

Yes

UNIQUE

Yes

Yes

UNPIVOT

Yes

Yes

USE

Yes

Yes

USING

Yes

Yes

SQL_CACHE

Yes

Yes

SQL_CALC_FOUND_ROWS

Yes

Yes

SQL_NO_CACHE

Yes

Yes

STRAIGHT_JOIN

Yes

Yes

TABLESAMPLE

Yes

VALUE

Yes

Yes

VALUES

Yes

Yes

VARYING

Yes

Yes

WHEN

Yes

Yes

WHERE

Yes

Yes

WINDOW

Yes

Yes

WITH

Yes

Yes

XOR

Yes

Yes

XMLSERIALIZE

Yes

Yes

SEL

Yes

Yes

SELECT

Yes

Yes

DATE

Yes

Yes

TIME

Yes

Yes

TIMESTAMP

Yes

Yes

YEAR

Yes

Yes

MONTH

Yes

Yes

DAY

Yes

Yes

HOUR

Yes

Yes

MINUTE

Yes

Yes

SECOND

Yes

Yes

SUBSTR

Yes

Yes

SUBSTRING

Yes

Yes

TRIM

Yes

Yes

POSITION

Yes

Yes

OVERLAY

Yes

Yes

NEXTVAL

Yes

0x

Yes

Yes