Skip to main content
Version: v4

3.5 Reserved Keywords

The following table lists all of the keywords that are reserved in Canner Enterprise, 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.

KeywordSQL:2016SQL-92
ANDreservedreserved
ASreservedreserved
BETWEENreservedreserved
BYreservedreserved
CASEreservedreserved
CASTreservedreserved
CONSTRAINTreservedreserved
CREATEreservedreserved
CROSS reservedreserved
CUBEreserved-
CURRENT_DATEreservedreserved
CURRENT_PATHreserved-
CURRENT_ROLEreservedreserved
CURRENT_TIMEreservedreserved
CURRENT_TIMESTAMPreservedreserved
CURRENT_USERreserved-
DEALLOCATEreservedreserved
DELETEreservedreserved
DESCRIBEreservedreserved
DISTINCTreservedreserved
DROPreservedreserved
ELSEreservedreserved
ENDreservedreserved
ESCAPEreservedreserved
EXCEPTreservedreserved
EXECUTEreservedreserved
EXISTSreservedreserved
EXTRACTreservedreserved
FALSE reservedreserved
FORreservedreserved
FROMreservedreserved
FULLreservedreserved
GROUP reservedreserved
GROUPINGreserved-
HAVINGreservedreserved
INreservedreserved
INNER reservedreserved
INSERTreservedreserved
INTERSECTreservedreserved
INTOreservedreserved
ISreservedreserved
JOINreservedreserved
LEFTreservedreserved
LIKEreservedreserved
LOCALTIMEreserved-
LOCALTIMESTAMPreserved-
NATURALreservedreserved
NORMALIZEreserved-
NOTreservedreserved
NULLreservedreserved
ONreservedreserved
ORreservedreserved
ORDER reservedreserved
OUTER reservedreserved
PREPAREreservedreserved
RECURSIVEreserved-
RIGHT reservedreserved
ROLLUPreserved-
SELECTreservedreserved
TABLE reservedreserved
THENreservedreserved
TRUEreservedreserved
UESCAPEreserved-
UNION reservedreserved
UNNESTreserved-
USING reservedreserved
VALUESreservedreserved
WHENreservedreserved
WHERE reservedreserved
WITHreservedreserved