8.2. 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.
| 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_PATH |
reserved | |
CURRENT_ROLE |
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 |