Keywords

SQL distinguishes between reserved and non-reserved keywords. According to the standard, reserved keywords are the only real keywords; they are never allowed as identifiers. Non-reserved keywords only have a special meaning in particular contexts and can be used as identifiers in other contexts. Most non-reserved keywords are actually the names of built-in tables and functions specified by SQL. The concept of non-reserved keywords essentially only exists to declare that some predefined meaning is attached to a word in some contexts.

?? a keyword not part of sys.keywords

!! a keyword not in PG

Reserved SQL keywords

Keywords reserved in the various SQL standards and freely used by MonetDB

KeywordMonetDBSQL:2016SQL:2011SQL-92
ABSreservedreserved
ACOSreserved
ASINreserved
ASSERTIONnon-reservednon-reservedreserved
ATANreserved
BOOLEANreservedreserved
BOTHreservedreservedreserved
CALLEDreservedreserved
CARDINALITYreservedreserved
COSreserved
COSHreserved
COUNTreservedreservedreserved
COVAR_POPreservedreserved
COVAR_SAMPreservedreserved
CUME_DISTreservedreserved
CURRENT_CATALOGreservedreservedreserved
CURRENT_DEFAULT_TRANSFORM_GROUPreservedreserved
DESCRIBEreservedreservedreserved
ELSEIFreservedreservedreserved
FETCHreservedreservedreserved
FLOATreservedreservedreserved
FLOORreservedreserved
INDICATORreservedreservedreserved
INTERSECTIONreservedreserved
LEADreservedreserved
LEADINGreservedreservedreserved
LOWERreservedreservedreserved
MEMBERreservedreserved
MINreservedreservedreserved
MINUTEreservedreservedreserved
MODreservedreserved
NONEreservedreserved
NORMALIZEreservedreserved
OMITreserved
ONEreserved
OUTreservedreserved
OUTPUTnon-reservednon-reservedreserved
OVERLAPSreservedreservedreserved
OVERLAYreservedreserved
PARAMETERreservedreserved
PATTERNreserved
PERreserved
PERCENTreservedreserved
PERCENTILE_CONTreservedreserved
PERCENTILE_DISCreservedreserved
PERCENT_RANKreservedreserved
PORTIONreservedreserved
POSITIONreservedreservedreserved
POSITION_REGEXreservedreserved
POWERreservedreserved
PRIORnon-reservednon-reservedreserved
READSreservedreserved
RANKreservedreserved
RECURSIVEreservedreserved
REFreservedreserved
REGR_AVGXreservedreserved
REGR_AVGYreservedreserved
REGR_COUNTreservedreserved
REGR_INTERCEPTreservedreserved
REGR_R2reservedreserved
REGR_SLOPEreservedreserved
REGR_SXXreservedreserved
REGR_SXYreservedreserved
REGR_SYYreservedreserved
RELATIVEnon-reservednon-reservedreserved
RELEASEreservedreserved
RESULTreservedreserved
ROWreservedreserved
ROW_NUMBERreservedreserved
SCOPEreservedreserved
SCROLLreservedreservedreserved
SEARCHreservedreserved
SECTIONnon-reservedreserved
SEEKreserved
SENSITIVEreservedreserved
SHOWreserved
SIMILARreservedreserved
SINreserved
SINHreserved
SIZEnon-reservednon-reservedreserved
SKIPreserved
SPACEnon-reservedreserved
SPECIFICreservedreserved
SPECIFICTYPEreservedreserved
SPECIFIC_NAMEnon-reservednon-reserved
STATICreservedreserved
STDDEV_POPreservedreserved
STDDEV_SAMPreservedreserved
SUBMULTISETreservedreserved
SUBSETreserved
SUBSTRING_REGEreservedreserved
SUCCEEDSreservedreserved
SUMreservedreservedreserved
SYSTEMreservedreserved
SYSTEM_TIMEreservedreserved
SYSTEM_USERreservedreservedreserved
TABLESAMPLEreservedreserved
TANreserved
TANHreserved
TIMEZONE_HOURreservedreservedreserved
TIMEZONE_MINUTEreservedreservedreserved
TRAILINGreservedreservedreserved
TRANSLATEreservedreservedreserved
TRANSLATE_REGEXreservedreserved
TRANSLATIONreservedreservedreserved
TREATreservedreserved
UNKNOWNreservedreservedreserved
UPPERreservedreservedreserved
USAGEnon-reservednon-reservedreserved
VALUEreservedreservedreserved
WIDTH_BUCKETreservedreserved
XMLSERIALIZEreservedreserved
XMLTABLEreservedreserved

Missing keywords in sys.keywords

KeywordSQL:2016SQL:2011SQL-92
ASreservedreservedreserved
BYreservedreservedreserved
CURRENT_PATHreservedreserved
CURRENT_ROLEreservedreservedreserved
CURRENT_TRANSFORM_GROUP_FOR_TYPEreservedreserved
FIRSTnon-reservednon-reservedreserved
JSON
ROLE
SQLreservedreservedreserved
SQLCODE
SQLERROR
SQLEXCEPTIONreservedreserved
SQLSTATEreservedreserved
SQLWARNINGreservedreserved
SQRTreservedreserved
TRIMreservedreserved
UESCAPEreservedreserved
VALUE_OFreservedreserved
VARBINARYreservedreserved
VARIADICreserved
VAR_POPreservedreserved
VAR_SAMPreservedreserved
VERBOSE
VERSIONINGreservedreserved
WHENEVERreservedreserved
WITHOUTreservedreserved
WITHINreservedreserved
XMLreservedreserved
XMLATTRIBUTESreservedreserved
XMLBINARYreservedreserved
XMLCASTreservedreserved
XMLEXISTSreservedreserved
XMLITERATEreservedreserved

MonetDB keywords

KeywordSQL:2016SQL:2011SQL-92
ADDnon-reservednon-reservedreserved
ADMINnon-reservednon-reserved
AFTERnon-reservednon-reservednon-reserved
AGGREGATEnon-reserved
ALLreservedreservedreserved
ALTERnon-reservedreservedreserved
ALWAYSnon-reservednon-reservednon-reserved
ANALYZEreserved
ANDreservedreservedreserved
ANYreservedreservedreserved
ASCnon-reservednon-reservedreserved
ASYMMETRICreservedreservedreserved
ATreservedreservedreserved
ATOMICnon-reservedreservedreserved
AUTHORIZATIONreservedreservedreserved
AUTO_INCREMENT
BEGINreservedreservedreserved
BEST
BETWEENreservedreservedreserved
BIGreservedreserved
BIGINTreservedreserved
BIGSERIALreservedreserved
BINARYreservedreserved
BLOBreservedreserved
BYreservedreservedreserved
Cnon-reservednon-reservednon-reserved
CACHE
CALLreservedreserved
CASCADEnon-reservednon-reservedreserved
CASEreservedreservedreserved
CASTreservedreservedreserved
CENTURY
CHAINnon-reservednon-reserved
CHARreservedreservedreserved
CHARACTERreservedreservedreserved
CHECKreservedreservedreserved
CLIENT
CLOBreservedreserved
COALESCEreservedreservedreserved
COLUMNreservedreservedreserved
COMMENT
COMMITreservedreservedreserved
COMMITTEDreservedreservedreserved
CONSTRAINTnon-reservednon-reservednon-reserved
CONTINUEnon-reservednon-reservedreserved
CONVERTreservedreservedreserved
COPYreserved
CORRESPONDINGreservedreservedreserved
CREATEreservedreservedreserved
CROSSreservedreservedreserved
CUBEreservedreserved
CURRENTreservedreservedreserved
CURRENT_DATEreservedreservedreserved
CURRENT_SCHEMAreservedreserved
CURRENT_TIMEreservedreservedreserved
CURRENT_TIMESTAMPreservedreservedreserved
CURRENT_USERreservedreservedreserved
CYCLEreservedreserved
DATAnon-reservednon-reservednon-reserved
DATEreservedreservedreserved
DAYreservedreservedreserved
DEALLOCATEreservedreservedreserved
DEBUG
DECreservedreservedreserved
DECADE
DECIMALreservedreservedreserved
DECLAREreservedreservedreserved
DEFAULTreservedreservedreserved
DELIMITERS
DESCnon-reservednon-reservedreserved
DIAGNOSTICSreserved
DISTINCTreservedreservedreserved
DO
DOUBLEreservedreservedreserved
DOW
DOY
DROPreservedreservedreserved
EACHreservedreserved
EFFORT
ELSEreservedreservedreserved
ENCRYPTED
ENDreservedreservedreserved
ENDIAN
EPOCH
ESCAPEreservedreservedreserved
EVERYreservedreserved
EXCEPTreservedreservedreserved
EXCLUDEnon-reservednon-reservednon-reserved
EXECreservedreservedreserved
EXECUTEreservedreservedreserved
EXISTSreservedreservedreserved
EXPLAINnon-reserved
EXTERNALreservedreservedreserved
EXTRACTreservedreservedreserved
FALSEreservedreservedreserved
FOLLOWINGnon-reservednon-reserved
FORreservedreservedreserved
FOREIGNreservedreservedreserved
FROMreservedreservedreserved
FULLreservedreservedreserved
FUNCTIONreservedreserved
FWF
GENERATEDnon-reservednon-reserved
GLOBALreservedreservedreserved
GRANTreservedreservedreserved
GROUPreservedreservedreserved
GROUPINGreservedreserved
GROUPSreservedreserved
HAVINGreservedreservedreserved
IDENTITYreservedreservedreserved
IF
ILIKE
INreservedreservedreserved
INCREMENTnon-reservednon-reserved
INDEX
INNERreservedreservedreserved
INSERTreservedreserved
INTreservedreservedreserved
INTEGERreservedreservedreserved
INTERSECTreservedreservedreserved
INTERVALreservedreservedreserved
INTOreservedreservedreserved
ISreservedreservedreserved
ISOLATIONnon-reservedreserved
JOINreservedreservedreserved
KEYnon-reservednon-reservedreserved
LANGUAGEreservedreservedreserved
LARGEreservedreserved
LASTon-reservednon-reservedreserved
LATERALreservedreservedreserved
LEFTreservedreservedreserved
LEVELnon-reservednon-reservedreserved
LIKEreservedreservedreserved
LIMITnon-reservednon-reserved
LITTLE
LOADER
LOCALreservedreserved
LOCALTIMEreservedreserved
LOCALTIMESTAMPreservedreserved
LOCKED
MATCHreservedreserved
MATCHEDnon-reservednon-reserved
MAXreservedreserved
MAXVALUEnon-reservednon-reserved
MEDIUMINT
MERGEreservedreserved
MINVALUEnon-reservednon-reserved
MONTHreservedreservedreserved
NAMEnon-reservednon-reserved
NATIVE
NATURALreservedreservedreserved
NEWreservedreserved
NEXTnon-reservednon-reservedreserved
NOreservedreservedreserved
NOTreservedreservedreserved
NTH_VALUEreservedreserved
NTILEreservedreserved
NULLreservedreservedreserved
NULLIFreservedreservedreserved
NULLSnon-reservednon-reserved
NUMERICreservedreservedreserved
OBJECTnon-reservednon-reserved
OFreservedreservedreserved
OFFSETreservedreserved
OLDreservedreserved
ONreservedreservedreserved
ONLYreservedreservedreserved
OPTIONnon-reservednon-reservedreserved
OPTIONSnon-reservednon-reserved
ORreservedreservedreserved
ORDERreservedreservedreserved
OTHERSnon-reservednon-reserved
OUTERreservedreservedreserved
OVERreservedreserved
PARTIALnon-reservednon-reservedreserved
PARTITIONreservedreserved
PASSWORD
PLANnon-reserved
PRECEDESreservedreserved
PRECEDING
PRECISIONreservedreservedreserved
PREP
PREPAREreservedreservedreserved
PRESERVEnon-reservedreserved
PRIMARYreservedreservedreserved
PRIVILEGESnon-reservednon-reservedreserved
PROCEDUREreservedreservedreserved
PUBLICnon-reservednon-reservedreserved
QUARTER
RANGEreservedreserved
READnon-reservednon-reservedreserved
REALreservedreservedreserved
REFERENCESreservedreservedreserved
REFERENCINGreservedreserved
REMOTE
RENAME
REPEATABLEnon-reservednon-reserved
REPLACE
REPLICA
RESTARTnon-reserved
RESTRICTnon-reservednon-reservedreserved
RETURNSreservedreserved
REVOKEreservedreservedreserved
RIGHTreservedreservedreserved
ROLLBACKreservedreservedreserved
ROLLUPreservedreserved
ROWSreservedreservedreserved
SAMPLE
SAVEPOINTreservedreserved
SCHEMAnon-reservednon-reservedreserved
SECONDreservedreservedreserved
SELECTreservedreservedreserved
SEQUENCEnon-reservednon-reserved
SERIAL
SERIALIZABLEnon-reservednon-reservednon-reserved
SERVERnon-reservednon-reserved
SESSIONnon-reservednon-reservedreserved
SESSION_USERreservedreservedreserved
SETreservedreservedreserved
SETS
SIMPLE
SMALLINTreservedreservedreserved
SOMEreservedreservedreserved
SPLIT_PART
STARTreservedreserved
STATEMENTnon-reservednon-reserved
STDIN
STDOUT
STORAGE
STRING
SUBSTRINGreservedreservedreserved
SYMMETRICreservedreservedreserved
TABLEreservedreservedreserved
TEMP
TEMPORARYnon-reservednon-reservedreserved
TEXT
THENreservedreservedreserved
TIESnon-reservednon-reserved
TIMEreservedreservedreserved
TIMESTAMPreservedreservedreserved
TOreservedreservedreserved
TRANSACTION
TRIGGERreservedreserved
TRUEreservedreservedreserved
TRUNCATEreservedreserved
TYPEnon-reservednon-reservednon-reserved
UNBOUNDEDnon-reservednon-reserved
UNCOMMITTEDnon-reservednon-reservednon-reserved
UNENCRYPTED
UNIONreservedreservedreserved
UNIQUEreservedreservedreserved
UNLOGGED
UPDATEreservedreservedreserved
UNNESTreservedreserved
USERreservedreservedreserved
USINGreservedreservedreserved
VALUESreservedreservedreserved
VARCHARreservedreservedreserved
VARYINGreservedreservedreserved
VIEWnon-reservednon-reservedreserved
WHENreservedreservedreserved
WHEREreservedreservedreserved
WHILE
WINDOWreservedreserved
WITHreservedreservedreserved
WORK
WRITEnon-reservednon-reservedreserved
XMLAGGreservedreserved
XMLCOMMENTreservedreserved
XMLCONCATreservedreserved
XMLDOCUMENTreservedreserved
XMLELEMENTreservedreserved
XMLFORESTreservedreserved
XMLNAMESPACESreservedreserved
XMLPARSEreservedreserved
XMLPIreservedreserved
XMLQUERYreservedreserved
XMLSCHEMA
XMLTEXTreservedreserved
XMLVALIDATEreservedreserved
YEARreservedreservedreserved
ZONEnon-reservednon-reservedreserved