Back to Presto

Reserved Keywords

presto-docs/src/main/sphinx/language/reserved.rst

0.2974.1 KB
Original Source

================= Reserved Keywords

The following table lists all of the keywords that are reserved in Presto, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier.

The use of $ as a prefix for column names is reserved. This is a convention only and it is not enforced.

============================== ============= ============= Keyword SQL:2016 SQL-92 ============================== ============= ============= ALTER reserved reserved AND reserved reserved AS reserved reserved BETWEEN reserved reserved BY reserved reserved CASE reserved reserved CAST reserved reserved CONSTRAINT reserved reserved CREATE reserved reserved CROSS reserved reserved CUBE reserved CURRENT_DATE reserved reserved CURRENT_TIME reserved reserved CURRENT_TIMESTAMP reserved reserved CURRENT_USER reserved DEALLOCATE reserved reserved DELETE reserved reserved DESCRIBE reserved reserved DISTINCT reserved reserved DROP reserved reserved ELSE reserved reserved END reserved reserved ESCAPE reserved reserved EXCEPT reserved reserved EXECUTE reserved reserved EXISTS reserved reserved EXTRACT reserved reserved FALSE reserved reserved FOR reserved reserved FROM reserved reserved FULL reserved reserved GROUP reserved reserved GROUPING reserved HAVING reserved reserved IN reserved reserved INNER reserved reserved INSERT reserved reserved INTERSECT reserved reserved INTO reserved reserved IS reserved reserved JOIN reserved reserved LEFT reserved reserved LIKE reserved reserved LOCALTIME reserved LOCALTIMESTAMP reserved NATURAL reserved reserved NORMALIZE reserved NOT reserved reserved NULL reserved reserved ON reserved reserved OR reserved reserved ORDER reserved reserved OUTER reserved reserved PREPARE reserved reserved RECURSIVE reserved RIGHT reserved reserved ROLLUP reserved SELECT reserved reserved TABLE reserved reserved THEN reserved reserved TRUE reserved reserved UESCAPE reserved UNION reserved reserved UNNEST reserved USING reserved reserved VALUES reserved reserved WHEN reserved reserved WHERE reserved reserved WITH reserved reserved ============================== ============= =============