General reference
Reserved words
Provides a list of reserved SQL words in Firebolt.
Reserved words have special meanings to the Firebolt SQL engine. We recommend that you do not use these words for naming databases, tables, columns, variables, or other objects that you define. If you must use a reserved word in this way, enclose it in quotation marks.
- ALL
- ALTER
- AND
- ARRAY
- BETWEEN
- BIGINT
- BOOL
- BOOLEAN
- BOTH
- CALL
- CASE
- CAST
- CHAR
- CONCAT
- COPY
- CREATE
- CROSS
- CURRENT_DATE
- CURRENT_TIMESTAMP
- DATABASE
- DATE
- DATETIME
- DECIMAL
- DELETE
- DESCRIBE
- DISTINCT
- DOUBLE
- DOUBLECOLON
- DOW
- DOY
- DROP
- EMPTY_IDENTIFIER
- ENGINE
- EPOCH
- EXCEPT
- EXECUTE
- EXISTS
- EXPLAIN
- EXTRACT
- FALSE
- FETCH
- FIRST
- FLOAT
- FROM
- FULL
- GENERATE
- GROUP
- HAVING
- IF
- ILIKE
- IN
- INNER
- INSERT
- INT
- INTEGER
- INTERSECT
- INTERVAL
- IS
- ISNULL
- JOIN
- JOIN_TYPE
- LATERAL
- LEADING
- LEFT
- LIKE
- LIMIT
- LIMIT_DISTINCT
- LOCALTIMESTAMP
- LONG
- NATURAL
- NEXT
- NOT
- NULL
- NUMERIC
- OFFSET
- ON
- ONLY
- OR
- ORDER
- OUTER
- OVER
- PARTITION
- PRECISION
- PREPARE
- PRIMARY
- QUARTER
- RIGHT
- ROW
- ROWS
- SAMPLE
- SELECT
- SET
- SHOW
- SYSTEM
- TEXT
- TIME
- TIMESTAMP
- TOP
- TRAILING
- TRIM
- TRUE
- TRUNCATE
- UNION
- UNKNOWN_CHAR
- UNNEST
- UNTERMINATED_STRING
- UPDATE
- USING
- VARCHAR
- WEEK
- WHEN
- WHERE
- WITH