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