HarperDB SQL Reserved Words

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
  • IANY
  • 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