Reserved Keywords

  • reference
This topic lists the SQL++ for Enterprise Analytics reserved keywords.

To include an identifier that is the same as a reserved keyword in a query, you must escape, or delimit, it with backtick (``) characters.

You must also delimit an identifier if it contains the dash - character, which is also used as an operator symbol.

For an example of the error that occurs when you do not escape a reserved keyword, see Syntax Errors.

The following keywords are reserved regardless of the case you use to enter them. Identifiers are case sensitive.

ADAPTER

ALL

ANALYZE

AND

ANY

APPLY

AS

ASC

AT

AUTOGENERATED

BETWEEN

BTREE

BUCKET

BY

CASE

CAST

CLOSED

COLLECTION

COMPACTION

COMPACT

CONNECT

COPY

CORRELATE

CREATE

CROSS

DATABASE

DATASET

DATAVERSE

DECLARE

DEFINITION

DELETE

DESC

DISCONNECT

DISTINCT

DIV

DROP

ELEMENT

ELSE

END

ENFORCED

EVERY

EXCEPT

EXISTS

EXPLAIN

EXTERNAL

FALSE

FEED

FILTER

FLATTEN

FOR

FROM

FULL

FULLTEXT

FUNCTION

GROUP

HAVING

HINTS

IF

IN

INDEX

INGESTION

INNER

INSERT

INTERNAL

INTERSECT

INTO

IS

JOIN

KEY

KEYWORD

KNOWN

LEFT

LET

LETTING

LIKE

LIMIT

LINK

LOAD

MISSING

MOD

NGRAM

NODEGROUP

NOT

NULL

OFFSET

ON

OPEN

OR

ORDER

OUTER

OUTPUT

OVER

PATH

POLICY

PRESORTED

PRIMARY

RAW

REFRESH

RETURN

RETURNING

RIGHT

RTREE

RUN

SATISFIES

SECONDARY

SELECT

SET

SHADOW

SOME

START

STOP

SYNONYM

TEMPORARY

THEN

TO

TRANSFORM

TRUE

TRUNCATE

TYPE

UNION

UNKNOWN

UNNEST

UPDATE

UPSERT

USE

USING

VALUE

VALUED

VIEW

WHEN

WHERE

WITH