Restricted KeywordsΒΆ
The following Keywords are restricted in JSQLParser-4.5 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 |
DEFAULT |
Yes |
|
DISTINCT |
Yes |
Yes |
DOUBLE |
Yes |
|
ELSE |
Yes |
Yes |
EXCEPT |
Yes |
Yes |
EXCLUDES |
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 |
HIGH |
Yes |
Yes |
IF |
Yes |
Yes |
IIF |
Yes |
|
IGNORE |
Yes |
|
ILIKE |
Yes |
Yes |
IN |
Yes |
Yes |
INCLUDES |
Yes |
Yes |
INNER |
Yes |
Yes |
INTERSECT |
Yes |
Yes |
INTERVAL |
Yes |
Yes |
INTO |
Yes |
Yes |
INVERSE |
Yes |
Yes |
IS |
Yes |
Yes |
JOIN |
Yes |
Yes |
LATERAL |
Yes |
Yes |
LEFT |
Yes |
Yes |
LIKE |
Yes |
Yes |
LIMIT |
Yes |
Yes |
LOW |
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 |
PLUS |
Yes |
Yes |
PREFERRING |
Yes |
Yes |
PROCEDURE |
Yes |
|
PUBLIC |
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 |