7.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 mustbe quoted (using double quotes) in order to be used as an identifier.

KeywordSQL:2016SQL-92
ALTERreservedreserved
ANDreservedreserved
ASreservedreserved
BETWEENreservedreserved
BYreservedreserved
CASEreservedreserved
CASTreservedreserved
CONSTRAINTreservedreserved
CREATEreservedreserved
CROSSreservedreserved
CUBEreserved
CURRENT_DATEreservedreserved
CURRENT_PATHreserved
CURRENT_TIMEreservedreserved
CURRENT_TIMESTAMPreservedreserved
CURRENT_USERreserved
DEALLOCATEreservedreserved
DELETEreservedreserved
DESCRIBEreservedreserved
DISTINCTreservedreserved
DROPreservedreserved
ELSEreservedreserved
ENDreservedreserved
ESCAPEreservedreserved
EXCEPTreservedreserved
EXECUTEreservedreserved
EXISTSreservedreserved
EXTRACTreservedreserved
FALSEreservedreserved
FORreservedreserved
FROMreservedreserved
FULLreservedreserved
GROUPreservedreserved
GROUPINGreserved
HAVINGreservedreserved
INreservedreserved
INNERreservedreserved
INSERTreservedreserved
INTERSECTreservedreserved
INTOreservedreserved
ISreservedreserved
JOINreservedreserved
LEFTreservedreserved
LIKEreservedreserved
LOCALTIMEreserved
LOCALTIMESTAMPreserved
NATURALreservedreserved
NORMALIZEreserved
NOTreservedreserved
NULLreservedreserved
ONreservedreserved
ORreservedreserved
ORDERreservedreserved
OUTERreservedreserved
PREPAREreservedreserved
RECURSIVEreserved
RIGHTreservedreserved
ROLLUPreserved
SELECTreservedreserved
TABLEreservedreserved
THENreservedreserved
TRUEreservedreserved
UESCAPEreserved
UNIONreservedreserved
UNNESTreserved
USINGreservedreserved
VALUESreservedreserved
WHENreservedreserved
WHEREreservedreserved
WITHreservedreserved