LogoLogo
4.1
4.1
  • Developer Documentation
  • Install HarperDB
    • On Linux
  • Getting Started
  • Full API Documentation
  • HarperDB Studio
    • Create an Account
    • Log In & Password Reset
    • Resources (Marketplace, Drivers, Tutorials, & Example Code)
    • Organizations
    • Instances
    • Query Instance Data
    • Manage Schemas / Browse Data
    • Manage Charts
    • Manage Clustering
    • Manage Instance Users
    • Manage Instance Roles
    • Manage Functions
    • Instance Metrics
    • Instance Configuration
    • Instance Example Code
    • Enable Mixed Content
  • HarperDB Cloud
    • IOPS Impact on Performance
    • Instance Size Hardware Specs
    • Alarms
    • Verizon 5G Wavelength
  • Security
    • JWT Authentication
    • Basic Authentication
    • Configuration
    • Users & Roles
  • Clustering
    • Requirements and Definitions
    • Creating A Cluster User
    • Naming A Node
    • Enabling Clustering
    • Establishing Routes
    • Subscription Overview
    • Managing Subscriptions
    • Things Worth Knowing
  • Custom Functions
    • Requirements and Definitions
    • Create a Project
    • Define Routes
    • Define Helpers
    • Host A Static Web UI
    • Using NPM and GIT
    • Custom Functions Operations
    • Restarting the Server
    • Debugging a Custom Function
    • Custom Functions Templates
    • Example Projects
  • Add-ons and SDKs
    • Google Data Studio
  • SQL Guide
    • SQL Features Matrix
    • Insert
    • Update
    • Delete
    • Select
    • Joins
    • SQL Date Functions
    • SQL Reserved Word
    • SQL Functions
    • SQL JSON Search
    • SQL Geospatial Functions
      • geoArea
      • geoLength
      • geoDifference
      • geoDistance
      • geoNear
      • geoContains
      • geoEqual
      • geoCrosses
      • geoConvert
  • HarperDB CLI
  • Configuration File
  • Logging
  • Transaction Logging
  • Audit Logging
  • Jobs
  • Upgrade a HarperDB Instance
  • Reference
    • Storage Algorithm
    • Dynamic Schema
    • Data Types
    • Content Types/Data Formats
    • HarperDB Headers
    • HarperDB Limits
  • Support
  • Release Notes
    • HarperDB Tucker (Version 4)
      • 4.1.0
      • 4.0.6
      • 4.0.5
      • 4.0.4
      • 4.0.3
      • 4.0.2
      • 4.0.1
      • 4.0.0
    • HarperDB Monkey (Version 3)
      • 3.3.0
      • 3.2.1
      • 3.2.0
      • 3.1.5
      • 3.1.4
      • 3.1.3
      • 3.1.2
      • 3.1.1
      • 3.1.0
      • 3.0.0
    • HarperDB Penny (Version 2)
      • 2.3.1
      • 2.3.0
      • 2.2.3
      • 2.2.2
      • 2.2.0
      • 2.1.1
    • HarperDB Alby (Version 1)
      • 1.3.1
      • 1.3.0
      • 1.2.0
      • 1.1.0
Powered by GitBook

© HarperDB. All Rights Reserved

On this page
Export as PDF
  1. SQL Guide

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

PreviousSQL Date FunctionsNextSQL Functions

Last updated 1 year ago