SQL Reserved Word

This is a list of reserved words in the SQL Parser. Use of these words or symbols may result in unexpected behavior or inaccessible tables/attributes. If any of these words must be used, any SQL call referencing a schema, table, or attribute must have backticks (…) or brackets ([…]) around the variable.

For Example, for a table called ASSERT in the dev schema, a SQL select on that table would look like:

SELECT * from dev.`ASSERT`

Alternatively:

SELECT * from dev.[ASSERT]

RESERVED WORD LIST

• ABSOLUTE

• ACTION

• ADD

• AGGR

• ALL

• ALTER

• AND

• ANTI

• ANY

• APPLY

• ARRAY

• AS

• ASSERT

• ASC

• ATTACH

• AUTOINCREMENT

• AUTO_INCREMENT

• AVG

• BEGIN

• BETWEEN

• BREAK

• BY

• CALL

• CASE

• CAST

• CHECK

• CLASS

• CLOSE

• COLLATE

• COLUMN

• COLUMNS

• COMMIT

• CONSTRAINT

• CONTENT

• CONTINUE

• CONVERT

• CORRESPONDING

• COUNT

• CREATE

• CROSS

• CUBE

• CURRENT_TIMESTAMP

• CURSOR

• DATABASE

• DECLARE

• DEFAULT

• DELETE

• DELETED

• DESC

• DETACH

• DISTINCT

• DOUBLEPRECISION

• DROP

• ECHO

• EDGE

• END

• ENUM

• ELSE

• EXCEPT

• EXISTS

• EXPLAIN

• FALSE

• FETCH

• FIRST

• FOREIGN

• FROM

• GO

• GRAPH

• GROUP

• GROUPING

• HAVING

• HDB_HASH

• HELP

• IF

• IDENTITY

• IS

• IN

• INDEX

• INNER

• INSERT

• INSERTED

• INTERSECT

• INTO

• JOIN

• KEY

• LAST

• LET

• LEFT

• LIKE

• LIMIT

• LOOP

• MATCHED

• MATRIX

• MAX

• MERGE

• MIN

• MINUS

• MODIFY

• NATURAL

• NEXT

• NEW

• NOCASE

• NO

• NOT

• NULL

• OFF

• ON

• ONLY

• OFFSET

• OPEN

• OPTION

• OR

• ORDER

• OUTER

• OVER

• PATH

• PARTITION

• PERCENT

• PLAN

• PRIMARY

• PRINT

• PRIOR

• QUERY

• READ

• RECORDSET

• REDUCE

• REFERENCES

• RELATIVE

• REPLACE

• REMOVE

• RENAME

• REQUIRE

• RESTORE

• RETURN

• RETURNS

• RIGHT

• ROLLBACK

• ROLLUP

• ROW

• SCHEMA

• SCHEMAS

• SEARCH

• SELECT

• SEMI

• SET

• SETS

• SHOW

• SOME

• SOURCE

• STRATEGY

• STORE

• SYSTEM

• SUM

• TABLE

• TABLES

• TARGET

• TEMP

• TEMPORARY

• TEXTSTRING

• THEN

• TIMEOUT

• TO

• TOP

• TRAN

• TRANSACTION

• TRIGGER

• TRUE

• TRUNCATE

• UNION

• UNIQUE

• UPDATE

• USE

• USING

• VALUE

• VERTEX

• VIEW

• WHEN

• WHERE

• WHILE

• WITH

• WORK