Reserved Keywords
- Capella Columnar
- reference
This topic lists the SQL++ for Capella columnar 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. |
ALL |
AND |
ANY |
APPLY |
AS |
ASC |
AT |
AUTOGENERATED |
BETWEEN |
BTREE |
BUCKET |
BY |
CASE |
CLOSED |
COLLECTION |
COMPACTION |
COMPACT |
CONNECT |
CORRELATE |
CREATE |
DATABASE |
DATASET |
DATAVERSE |
|
DECLARE |
DEFINITION |
DELETE |
DESC |
DISCONNECT |
|
DISTINCT |
DROP |
ELEMENT |
ELSE |
END |
ENFORCED |
EVERY |
EXCEPT |
EXISTS |
EXPLAIN |
EXTERNAL |
FEED |
FILTER |
FLATTEN |
FOR |
FROM |
FULL |
FUNCTION |
GROUP |
HAVING |
HINTS |
IF |
INTO |
IN |
INDEX |
INGESTION |
INNER |
INSERT |
INTERNAL |
INTERSECT |
IS |
JOIN |
KEYWORD |
KEY |
LEFT |
LETTING |
LET |
LIKE |
LIMIT |
LINK |
LOAD |
NGRAM |
NODEGROUP |
NOT |
OFFSET |
ON |
OPEN |
OR |
ORDER |
OUTER |
OUTPUT |
OVER |
PATH |
POLICY |
PRE-SORTED |
PRIMARY |
RAW |
REFRESH |
RETURN |
RTREE |
RUN |
SATISFIES |
SECONDARY |
SELECT |
SET |
SHADOW |
SOME |
SYNONYM |
TEMPORARY |
THEN |
TYPE |
TO |
UNION |
UNKNOWN |
UNNEST |
UPDATE |
USE |
USING |
VALUE |
WHEN |
WHERE |
WITH |
WRITE |