LogoLogo
Studio
4.2
4.2
  • HarperDB Docs
  • Getting Started
  • Developers
    • Applications
      • Caching
      • Defining Schemas
      • Debugging Applications
      • Define Fastify Routes
      • Example Projects
    • Components
      • Installing
      • Writing Extensions
      • Operations
      • Google Data Studio
      • SDKs
      • Drivers
    • REST
    • Operations API
      • Quick Start Examples
      • Databases and Tables
      • NoSQL Operations
      • Bulk Operations
      • Users and Roles
      • Clustering
      • Custom Functions
      • Components
      • Registration
      • Jobs
      • Logs
      • Utilities
      • Token Authentication
      • SQL Operations
      • Advanced JSON SQL Examples
    • Real-Time
    • Clustering
      • Requirements and Definitions
      • Creating A Cluster User
      • Naming A Node
      • Enabling Clustering
      • Establishing Routes
      • Subscription Overview
      • Managing Subscriptions
      • Things Worth Knowing
      • Certificate Management
    • Security
      • JWT Authentication
      • Basic Authentication
      • Configuration
      • Users & Roles
      • Certificate Management
    • SQL Guide
      • SQL Features Matrix
      • SQL Date Functions
      • SQL Reserved Word
      • SQL Functions
      • SQL JSON Search
      • SQL Geospatial Functions
  • Administration
    • Best Practices and Recommendations
    • Logging
      • Standard Logging
      • Audit Logging
      • Transaction Logging
    • Clone Node
    • Jobs
    • HarperDB Studio
      • Create an Account
      • Log In & Password Reset
      • 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
  • Deployments
    • Configuration File
    • HarperDB CLI
    • Install HarperDB
      • On Linux
    • Upgrade a HarperDB Instance
    • HarperDB Cloud
      • IOPS Impact on Performance
      • Instance Size Hardware Specs
      • Alarms
      • Verizon 5G Wavelength
  • Technical Details
    • Reference
      • Analytics
      • Architecture
      • Content Types
      • Data Types
      • Dynamic Schema
      • HarperDB Headers
      • HarperDB Limits
      • Globals
      • Resource Class
      • Transactions
      • Storage Algorithm
    • Release Notes
      • HarperDB Tucker (Version 4)
        • 4.2.8
        • 4.2.7
        • 4.2.6
        • 4.2.5
        • 4.2.4
        • 4.2.3
        • 4.2.2
        • 4.2.1
        • 4.2.0
        • 4.1.2
        • 4.1.1
        • 4.1.0
        • 4.0.7
        • 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
  • More Help
    • Support
    • Slack
    • Contact Us
Powered by GitBook
On this page
  1. Developers
  2. 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