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