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 |