Appendix C. SQL Key Words

Table C.1 lists all tokens that are key words in the SQL standard and in LightDB 13.3-22.2. Background information can be found in Section 4.1.1. (For space reasons, only the latest two versions of the SQL standard, and SQL-92 for historical comparison, are included. The differences between those and the other intermediate standard versions are small.)

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

In the LightDB parser life is a bit more complicated. There are several different classes of tokens ranging from those that can never be used as an identifier to those that have absolutely no special status in the parser as compared to an ordinary identifier. (The latter is usually the case for functions specified by SQL.) Even reserved key words are not completely reserved in LightDB, but can be used as column labels (for example, SELECT 55 AS CHECK, even though CHECK is a reserved key word).

In Table C.1 in the column for LightDB we classify as non-reserved those key words that are explicitly known to the parser but are allowed as column or table names. Some key words that are otherwise non-reserved cannot be used as function or data type names and are marked accordingly. (Most of these words represent built-in functions or data types with special syntax. The function or type is still available but it cannot be redefined by the user.) Labeled reserved are those tokens that are not allowed as column or table names. Some reserved key words are allowable as names for functions or data types; this is also shown in the table. If not so marked, a reserved key word is only allowed as an AS column label name.

As a general rule, if you get spurious parser errors for commands that contain any of the listed key words as an identifier you should try to quote the identifier to see if the problem goes away.

It is important to understand before studying Table C.1 that the fact that a key word is not reserved in LightDB does not mean that the feature related to the word is not implemented. Conversely, the presence of a key word does not indicate the existence of a feature.

Table C.1. SQL Key Words

Key WordPostgreSQLLightDBSQL:2016SQL:2011SQL-92
A     
ABORTnon-reserved non-reservednon-reservednon-reserved
ABS     
ABSENT     
ABSOLUTEnon-reserved non-reservednon-reservednon-reserved
ACCESSnon-reserved non-reservednon-reservednon-reserved
ACCORDING     
ACOS     
ACTIONnon-reserved non-reservednon-reservednon-reserved
ACTIVEnon-reserved non-reservednon-reservednon-reserved
ADA     
ADDnon-reserved non-reservednon-reservednon-reserved
ADMINnon-reserved non-reservednon-reservednon-reserved
AFTERnon-reserved non-reservednon-reservednon-reserved
AGGREGATEnon-reserved non-reservednon-reservednon-reserved
ALLreserved reservedreservedreserved
ALLOCATE     
ALSOnon-reserved non-reservednon-reservednon-reserved
ALTERnon-reserved non-reservednon-reservednon-reserved
ALWAYSnon-reserved non-reservednon-reservednon-reserved
ANALYSEreserved reservedreservedreserved
ANALYZEreserved reservedreservedreserved
ANDreserved reservedreservedreserved
ANYreserved reservedreservedreserved
APPEND non-reservednon-reservednon-reservednon-reserved
ARE     
ARRAYreserved reservedreservedreserved
ARRAY_AGG     
ARRAY_​MAX_​CARDINALITY     
ASreserved reservedreservedreserved
ASCreserved reservedreservedreserved
ASENSITIVE non-reservednon-reservednon-reservednon-reserved
ASIN     
ASSERTIONnon-reserved non-reservednon-reservednon-reserved
ASSIGNMENTnon-reserved non-reservednon-reservednon-reserved
ASYMMETRICreserved reservedreservedreserved
ATnon-reserved non-reservednon-reservednon-reserved
ATAN     
ATOMIC     
ATTACHnon-reserved non-reservednon-reservednon-reserved
ATTRIBUTEnon-reserved non-reservednon-reservednon-reserved
ATTRIBUTES     
AUTHID non-reservednon-reservednon-reservednon-reserved
AUTHORIZATIONreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
AUTO_INCREMENT reservedreservedreservedreserved
AVG     
BACKWARDnon-reserved non-reservednon-reservednon-reserved
BASE64     
BEFOREnon-reserved non-reservednon-reservednon-reserved
BEGINnon-reserved non-reservednon-reservednon-reserved
BEGIN_FRAME     
BEGIN_PARTITION     
BERNOULLI     
BETWEENnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
BIGINTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
BINARYreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
BITnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
BIT_LENGTH     
BLOB     
BLOCKED     
BODY non-reservednon-reservednon-reservednon-reserved
BOM     
BOOLEANnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
BOTHreserved reservedreservedreserved
BREADTH     
BYnon-reserved non-reservednon-reservednon-reserved
C     
CACHEnon-reserved non-reservednon-reservednon-reserved
CALLnon-reserved non-reservednon-reservednon-reserved
CALLEDnon-reserved non-reservednon-reservednon-reserved
CARDINALITY     
CASCADEnon-reserved non-reservednon-reservednon-reserved
CASCADEDnon-reserved non-reservednon-reservednon-reserved
CASEreserved reservedreservedreserved
CASTreserved reservedreservedreserved
CATALOGnon-reserved non-reservednon-reservednon-reserved
CATALOG_NAME     
CEIL     
CEILING     
CHAINnon-reserved non-reservednon-reservednon-reserved
CHAINING     
CHARnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
CHARACTERnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
CHARACTERISTICSnon-reserved non-reservednon-reservednon-reserved
CHARACTERS     
CHARACTER_LENGTH     
CHARACTER_​SET_​CATALOG     
CHARACTER_SET_NAME     
CHARACTER_SET_SCHEMA     
CHAR_LENGTH     
CHECKreserved reservedreservedreserved
CHECKPOINTnon-reserved non-reservednon-reservednon-reserved
CLASSnon-reserved non-reservednon-reservednon-reserved
CLASSIFIER     
CLASS_ORIGIN     
CLOB     
CLOSEnon-reserved non-reservednon-reservednon-reserved
CLUSTERnon-reserved non-reservednon-reservednon-reserved
COALESCEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
COBOL     
COLLATEreserved reservedreservedreserved
COLLATIONreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
COLLATION_CATALOG     
COLLATION_NAME     
COLLATION_SCHEMA     
COLLECT     
COLOCATE_WITH non-reservednon-reservednon-reservednon-reserved
COLUMNreserved reservedreservedreserved
COLUMNSnon-reserved non-reservednon-reservednon-reserved
COLUMN_NAME     
COMMAND_FUNCTION     
COMMAND_​FUNCTION_​CODE     
COMMENTnon-reserved non-reservednon-reservednon-reserved
COMMENTSnon-reserved non-reservednon-reservednon-reserved
COMMITnon-reserved non-reservednon-reservednon-reserved
COMMITTEDnon-reserved non-reservednon-reservednon-reserved
CONCURRENCYnon-reserved non-reservednon-reservednon-reserved
CONCURRENTLYreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
CONDITION     
CONDITIONAL     
CONDITION_NUMBER     
CONFIGURATIONnon-reserved non-reservednon-reservednon-reserved
CONFLICTnon-reserved non-reservednon-reservednon-reserved
CONNECT     
CONNECTIONnon-reserved non-reservednon-reservednon-reserved
CONNECTION_NAME     
CONSTRAINTreserved reservedreservedreserved
CONSTRAINTSnon-reserved non-reservednon-reservednon-reserved
CONSTRAINT_CATALOG     
CONSTRAINT_NAME     
CONSTRAINT_SCHEMA     
CONSTRUCTOR     
CONTAINSnon-reserved non-reservednon-reservednon-reserved
CONTENTnon-reserved non-reservednon-reservednon-reserved
CONTINUEnon-reserved non-reservednon-reservednon-reserved
CONTROL     
CONVERSIONnon-reserved non-reservednon-reservednon-reserved
CONVERT     
COPYnon-reserved non-reservednon-reservednon-reserved
CORR     
CORRESPONDING     
COS     
COSH     
COSTnon-reserved non-reservednon-reservednon-reserved
COUNT     
COVAR_POP     
COVAR_SAMP     
CREATEreserved reservedreservedreserved
CROSSreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
CSVnon-reserved non-reservednon-reservednon-reserved
CUBEnon-reserved non-reservednon-reservednon-reserved
CUME_DIST     
CURRENTnon-reserved non-reservednon-reservednon-reserved
CURRENT_CATALOGreserved reservedreservedreserved
CURRENT_DATEreserved reservedreservedreserved
CURRENT_​DEFAULT_​TRANSFORM_​GROUP     
CURRENT_PATH     
CURRENT_ROLEreserved reservedreservedreserved
CURRENT_ROW     
CURRENT_SCHEMAreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
CURRENT_TIMEreserved reservedreservedreserved
CURRENT_TIMESTAMPreserved reservedreservedreserved
CURRENT_​TRANSFORM_​GROUP_​FOR_​TYPE     
CURRENT_USERreserved reservedreservedreserved
CURSORnon-reserved non-reservednon-reservednon-reserved
CURSOR_NAME     
CYCLEnon-reserved non-reservednon-reservednon-reserved
DATAnon-reserved non-reservednon-reservednon-reserved
DATABASEnon-reserved non-reservednon-reservednon-reserved
DATALINK     
DATE     
DATETIME non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
DATETIME_​INTERVAL_​CODE     
DATETIME_​INTERVAL_​PRECISION     
DAYnon-reserved non-reservednon-reservednon-reserved
DB     
DEALLOCATEnon-reserved non-reservednon-reservednon-reserved
DECnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
DECFLOAT     
DECIMALnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
DECLAREnon-reserved non-reservednon-reservednon-reserved
DEFAULTreserved reservedreservedreserved
DEFAULTSnon-reserved non-reservednon-reservednon-reserved
DEFERRABLEreserved reservedreservedreserved
DEFERREDnon-reserved non-reservednon-reservednon-reserved
DEFINE     
DEFINED     
DEFINERnon-reserved non-reservednon-reservednon-reserved
DEGREE     
DELETEnon-reserved non-reservednon-reservednon-reserved
DELIMITERnon-reserved non-reservednon-reservednon-reserved
DELIMITERSnon-reserved non-reservednon-reservednon-reserved
DENSE_RANK     
DEPENDSnon-reserved non-reservednon-reservednon-reserved
DEPTH     
DEREF     
DERIVED     
DESCreserved reservedreservedreserved
DESCRIBE     
DESCRIPTOR     
DETACHnon-reserved non-reservednon-reservednon-reserved
DETERMINISTIC     
DIAGNOSTICS     
DICTIONARYnon-reserved non-reservednon-reservednon-reserved
DISABLEnon-reserved non-reservednon-reservednon-reserved
DISCARDnon-reserved non-reservednon-reservednon-reserved
DISCONNECT     
DISPATCH     
DISTINCTreserved reservedreservedreserved
DISTRIBUTED reservedreservedreservedreserved
DLNEWCOPY     
DLPREVIOUSCOPY     
DLURLCOMPLETE     
DLURLCOMPLETEONLY     
DLURLCOMPLETEWRITE     
DLURLPATH     
DLURLPATHONLY     
DLURLPATHWRITE     
DLURLSCHEME     
DLURLSERVER     
DLVALUE     
DOreserved reservedreservedreserved
DOCUMENTnon-reserved non-reservednon-reservednon-reserved
DOMAINnon-reserved non-reservednon-reservednon-reserved
DOUBLEnon-reserved non-reservednon-reservednon-reserved
DROPnon-reserved non-reservednon-reservednon-reserved
DYNAMIC     
DYNAMIC_FUNCTION     
DYNAMIC_​FUNCTION_​CODE     
EACHnon-reserved non-reservednon-reservednon-reserved
ELEMENT     
ELSEreserved reservedreservedreserved
ELSIF non-reservednon-reservednon-reservednon-reserved
EMPTY     
ENABLEnon-reserved non-reservednon-reservednon-reserved
ENCODINGnon-reserved non-reservednon-reservednon-reserved
ENCRYPTEDnon-reserved non-reservednon-reservednon-reserved
ENDreserved reservedreservedreserved
END-EXEC     
END_FRAME     
END_PARTITION     
ENFORCED     
ENUMnon-reserved non-reservednon-reservednon-reserved
EQUALS     
ERROR     
ESCAPEnon-reserved non-reservednon-reservednon-reserved
EVENTnon-reserved non-reservednon-reservednon-reserved
EVERYnon-reserved non-reservednon-reservednon-reserved
EXCEPT reservedreservedreservedreserved
EXCEPTIONnon-reserved non-reservednon-reservednon-reserved
EXCHANGEnon-reserved non-reservednon-reservednon-reserved
EXCLUDEreserved reservedreservedreserved
EXCLUDINGnon-reserved non-reservednon-reservednon-reserved
EXCLUSIVEnon-reserved non-reservednon-reservednon-reserved
EXEC     
EXECUTEnon-reserved non-reservednon-reservednon-reserved
EXISTSnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
EXP     
EXPAND non-reservednon-reservednon-reservednon-reserved
EXPLAINnon-reserved non-reservednon-reservednon-reserved
EXPRESSIONnon-reserved non-reservednon-reservednon-reserved
EXTENSIONnon-reserved non-reservednon-reservednon-reserved
EXTERNALnon-reserved non-reservednon-reservednon-reserved
EXTRACTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
FALSEreserved reservedreservedreserved
FAMILYnon-reserved non-reservednon-reservednon-reserved
FETCHreserved reservedreservedreserved
FILE     
FILTERnon-reserved non-reservednon-reservednon-reserved
FINAL     
FINISH     
FIRSTnon-reserved non-reservednon-reservednon-reserved
FIRST_VALUE     
FLAG     
FLOATnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
FLOOR     
FOLLOWINGreserved reservedreservedreserved
FORreserved reservedreservedreserved
FORCEnon-reserved non-reservednon-reservednon-reserved
FOREIGNreserved reservedreservedreserved
FORMATnon-reserved non-reservednon-reservednon-reserved
FORTRAN     
FORWARDnon-reserved non-reservednon-reservednon-reserved
FOUND     
FRAME_ROW     
FREE     
FREEZEreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
FROMreserved reservedreservedreserved
FS     
FULFILL     
FULLreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
FULLSCANnon-reserved non-reservednon-reservednon-reserved
FUNCTIONnon-reserved non-reservednon-reservednon-reserved
FUNCTIONSnon-reserved non-reservednon-reservednon-reserved
FUSION     
G     
GENERAL     
GENERATEDnon-reserved non-reservednon-reservednon-reserved
GET     
GLOBALnon-reserved non-reservednon-reservednon-reserved
GO     
GOTO     
GRANTreserved reservedreservedreserved
GRANTEDnon-reserved non-reservednon-reservednon-reserved
GREATESTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
GROUPreserved reservedreservedreserved
GROUPINGnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
GROUPSnon-reserved non-reservednon-reservednon-reserved
GROUP_CONCAT reservedreservedreservedreserved
HANDLERnon-reserved non-reservednon-reservednon-reserved
HASHnon-reserved non-reservednon-reservednon-reserved
HAVINGreserved reservedreservedreserved
HEADERnon-reserved non-reservednon-reservednon-reserved
HEX     
HIERARCHY     
HOLDnon-reserved non-reservednon-reservednon-reserved
HOURnon-reserved non-reservednon-reservednon-reserved
ID     
IDENTITYnon-reserved non-reservednon-reservednon-reserved
IFnon-reserved non-reservednon-reservednon-reserved
IGNOREnon-reserved non-reservednon-reservednon-reserved
ILIKEreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
IMMEDIATEnon-reserved non-reservednon-reservednon-reserved
IMMEDIATELY     
IMMUTABLEnon-reserved non-reservednon-reservednon-reserved
IMPLEMENTATION     
IMPLICITnon-reserved non-reservednon-reservednon-reserved
IMPORTnon-reserved non-reservednon-reservednon-reserved
INreserved reservedreservedreserved
INCLUDEnon-reserved non-reservednon-reservednon-reserved
INCLUDINGnon-reserved non-reservednon-reservednon-reserved
INCLUSIVE non-reservednon-reservednon-reservednon-reserved
INCREMENTnon-reserved non-reservednon-reservednon-reserved
INDENT     
INDEXnon-reserved non-reservednon-reservednon-reserved
INDEXESnon-reserved non-reservednon-reservednon-reserved
INDICATOR     
INHERITnon-reserved non-reservednon-reservednon-reserved
INHERITSnon-reserved non-reservednon-reservednon-reserved
INITIAL     
INITIALLYreserved reservedreservedreserved
INLINEnon-reserved non-reservednon-reservednon-reserved
INNERreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
INOUTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
INPUTnon-reserved non-reservednon-reservednon-reserved
INSENSITIVEnon-reserved non-reservednon-reservednon-reserved
INSERTnon-reserved non-reservednon-reservednon-reserved
INSTANCE     
INSTANTIABLE     
INSTEADnon-reserved non-reservednon-reservednon-reserved
INTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
INTEGERnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
INTEGRITY     
INTERSECTreserved reservedreservedreserved
INTERSECTION     
INTERVALnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
INTOreserved reservedreservedreserved
INVOKERnon-reserved non-reservednon-reservednon-reserved
ISreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
ISNULLreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
ISOLATIONnon-reserved non-reservednon-reservednon-reserved
JOINreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
JSON     
JSON_ARRAY     
JSON_ARRAYAGG     
JSON_EXISTS     
JSON_OBJECT     
JSON_OBJECTAGG     
JSON_QUERY     
JSON_TABLE     
JSON_TABLE_PRIMITIVE     
JSON_VALUE     
K     
KEEP     
KEYnon-reserved non-reservednon-reservednon-reserved
KEYS     
KEY_MEMBER     
KEY_TYPE     
LABELnon-reserved non-reservednon-reservednon-reserved
LAG     
LANGUAGEnon-reserved non-reservednon-reservednon-reserved
LARGEnon-reserved non-reservednon-reservednon-reserved
LASTnon-reserved non-reservednon-reservednon-reserved
LAST_VALUE     
LATERALreserved reservedreservedreserved
LEAD     
LEADINGreserved reservedreservedreserved
LEAKPROOFnon-reserved non-reservednon-reservednon-reserved
LEASTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
LEFTreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
LENGTH     
LEVELnon-reserved non-reservednon-reservednon-reserved
LIBRARY     
LIKEreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
LIKE_REGEX     
LIMITreserved reservedreservedreserved
LINK     
LISTnon-reserved non-reservednon-reservednon-reserved
LISTAGG     
LISTENnon-reserved non-reservednon-reservednon-reserved
LN     
LOADnon-reserved non-reservednon-reservednon-reserved
LOCALnon-reserved non-reservednon-reservednon-reserved
LOCALTIMEreserved reservedreservedreserved
LOCALTIMESTAMPreserved reservedreservedreserved
LOCATIONnon-reserved non-reservednon-reservednon-reserved
LOCATOR     
LOCKnon-reserved non-reservednon-reservednon-reserved
LOCKEDnon-reserved non-reservednon-reservednon-reserved
LOG     
LOG10     
LOGGEDnon-reserved non-reservednon-reservednon-reserved
LOOP non-reservednon-reservednon-reservednon-reserved
LOWER     
M     
MAP     
MAPPINGnon-reserved non-reservednon-reservednon-reserved
MASTER non-reservednon-reservednon-reservednon-reserved
MATCHnon-reserved non-reservednon-reservednon-reserved
MATCHED non-reservednon-reservednon-reservednon-reserved
MATCHES     
MATCH_NUMBER     
MATCH_RECOGNIZE     
MATERIALIZEDnon-reserved non-reservednon-reservednon-reserved
MAX     
MAXVALUEnon-reserved non-reservednon-reservednon-reserved
MEASURES     
MEMBER     
MERGE non-reservednon-reservednon-reservednon-reserved
MESSAGE_LENGTH     
MESSAGE_OCTET_LENGTH     
MESSAGE_TEXT     
METHODnon-reserved non-reservednon-reservednon-reserved
MIN     
MINUS reservedreservedreservedreserved
MINUTEnon-reserved non-reservednon-reservednon-reserved
MINVALUEnon-reserved non-reservednon-reservednon-reserved
MISSINGnon-reserved non-reservednon-reservednon-reserved
MOD     
MODEnon-reserved non-reservednon-reservednon-reserved
MODIFIES     
MODULE     
MONTHnon-reserved non-reservednon-reservednon-reserved
MORE     
MOVEnon-reserved non-reservednon-reservednon-reserved
MULTISET     
MUMPS     
NAMEnon-reserved non-reservednon-reservednon-reserved
NAMESnon-reserved non-reservednon-reservednon-reserved
NAMESPACE     
NATIONALnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NATURALreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
NCHARnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NCLOB     
NESTED     
NESTING     
NEWnon-reserved non-reservednon-reservednon-reserved
NEXTnon-reserved non-reservednon-reservednon-reserved
NFCnon-reserved non-reservednon-reservednon-reserved
NFDnon-reserved non-reservednon-reservednon-reserved
NFKCnon-reserved non-reservednon-reservednon-reserved
NFKDnon-reserved non-reservednon-reservednon-reserved
NIL     
NOnon-reserved non-reservednon-reservednon-reserved
NONEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NORMALIZEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NORMALIZEDnon-reserved non-reservednon-reservednon-reserved
NOTreserved reservedreservedreserved
NOTHINGnon-reserved non-reservednon-reservednon-reserved
NOTIFYnon-reserved non-reservednon-reservednon-reserved
NOTNULLreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
NOWAITnon-reserved non-reservednon-reservednon-reserved
NTH_VALUE     
NTILE     
NULLreserved reservedreservedreserved
NULLABLE     
NULLIFnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NULLSnon-reserved non-reservednon-reservednon-reserved
NUMBER non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
NUMERICnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
OBJECTnon-reserved non-reservednon-reservednon-reserved
OCCURRENCES_REGEX     
OCTETS     
OCTET_LENGTH     
OFnon-reserved non-reservednon-reservednon-reserved
OFFnon-reserved non-reservednon-reservednon-reserved
OFFSETreserved reservedreservedreserved
OIDSnon-reserved non-reservednon-reservednon-reserved
OLDnon-reserved non-reservednon-reservednon-reserved
OMIT     
ONreserved reservedreservedreserved
ONE     
ONLYreserved reservedreservedreserved
OPEN     
OPERATORnon-reserved non-reservednon-reservednon-reserved
OPTIONnon-reserved non-reservednon-reservednon-reserved
OPTIONSnon-reserved non-reservednon-reservednon-reserved
ORreserved reservedreservedreserved
ORDERreserved reservedreservedreserved
ORDEREDnon-reserved non-reservednon-reservednon-reserved
ORDERING     
ORDINALITYnon-reserved non-reservednon-reservednon-reserved
OTHERSnon-reserved non-reservednon-reservednon-reserved
OUTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
OUTERreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
OUTPUT     
OVERnon-reserved non-reservednon-reservednon-reserved
OVERFLOW     
OVERLAPSreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
OVERLAYnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
OVERRIDINGnon-reserved non-reservednon-reservednon-reserved
OWNEDnon-reserved non-reservednon-reservednon-reserved
OWNERnon-reserved non-reservednon-reservednon-reserved
P     
PACKAGE non-reservednon-reservednon-reservednon-reserved
PAD     
PARALLELnon-reserved non-reservednon-reservednon-reserved
PARALLEL_ENABLE non-reservednon-reservednon-reservednon-reserved
PARAMETER     
PARAMETER_MODE     
PARAMETER_NAME     
PARAMETER_​ORDINAL_​POSITION     
PARAMETER_​SPECIFIC_​CATALOG     
PARAMETER_​SPECIFIC_​NAME     
PARAMETER_​SPECIFIC_​SCHEMA     
PARSERnon-reserved non-reservednon-reservednon-reserved
PARTIALnon-reserved non-reservednon-reservednon-reserved
PARTITIONreserved reservedreservedreserved
PARTITIONS non-reservednon-reservednon-reservednon-reserved
PASCAL     
PASS     
PASSINGnon-reserved non-reservednon-reservednon-reserved
PASSTHROUGH     
PASSWORDnon-reserved non-reservednon-reservednon-reserved
PAST     
PATH     
PATTERN     
PER     
PERCENT     
PERCENTILE_CONT     
PERCENTILE_DISC     
PERCENT_RANK     
PERIOD     
PERMISSION     
PERMUTE     
PLACINGreserved reservedreservedreserved
PLAN     
PLANSnon-reserved non-reservednon-reservednon-reserved
PLI     
POLICYnon-reserved non-reservednon-reservednon-reserved
PORTION     
POSITIONnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
POSITION_REGEX     
POWER     
PRECEDES     
PRECEDINGreserved reservedreservedreserved
PRECISIONnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
PREPAREnon-reserved non-reservednon-reservednon-reserved
PREPAREDnon-reserved non-reservednon-reservednon-reserved
PRESERVEnon-reserved non-reservednon-reservednon-reserved
PRIMARYreserved reservedreservedreserved
PRIORnon-reserved non-reservednon-reservednon-reserved
PRIVATE     
PRIVILEGESnon-reserved non-reservednon-reservednon-reserved
PROCEDURALnon-reserved non-reservednon-reservednon-reserved
PROCEDUREnon-reserved non-reservednon-reservednon-reserved
PROCEDURESnon-reserved non-reservednon-reservednon-reserved
PROGRAMnon-reserved non-reservednon-reservednon-reserved
PRUNE     
PTF     
PUBLIC     
PUBLICATIONnon-reserved non-reservednon-reservednon-reserved
QUOTEnon-reserved non-reservednon-reservednon-reserved
QUOTES     
RANDOMLY non-reservednon-reservednon-reservednon-reserved
RANGEnon-reserved non-reservednon-reservednon-reserved
RANK     
READnon-reserved non-reservednon-reservednon-reserved
READABLE non-reservednon-reservednon-reservednon-reserved
READS     
REALnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
REASSIGNnon-reserved non-reservednon-reservednon-reserved
RECHECKnon-reserved non-reservednon-reservednon-reserved
RECORD non-reservednon-reservednon-reservednon-reserved
RECOVERY     
RECURSIVEnon-reserved non-reservednon-reservednon-reserved
REFnon-reserved non-reservednon-reservednon-reserved
REFERENCESreserved reservedreservedreserved
REFERENCINGnon-reserved non-reservednon-reservednon-reserved
REFRESHnon-reserved non-reservednon-reservednon-reserved
REGR_AVGX     
REGR_AVGY     
REGR_COUNT     
REGR_INTERCEPT     
REGR_R2     
REGR_SLOPE     
REGR_SXX     
REGR_SXY     
REGR_SYY     
REINDEXnon-reserved non-reservednon-reservednon-reserved
RELATIVEnon-reserved non-reservednon-reservednon-reserved
RELEASEnon-reserved non-reservednon-reservednon-reserved
RENAMEnon-reserved non-reservednon-reservednon-reserved
REPEATABLEnon-reserved non-reservednon-reservednon-reserved
REPLACEnon-reserved non-reservednon-reservednon-reserved
REPLICAnon-reserved non-reservednon-reservednon-reserved
REPLICATED non-reservednon-reservednon-reservednon-reserved
REQUIRING     
RESETnon-reserved non-reservednon-reservednon-reserved
RESPECT     
RESTARTnon-reserved non-reservednon-reservednon-reserved
RESTORE     
RESTRICTnon-reserved non-reservednon-reservednon-reserved
RESULT     
RETURN non-reservednon-reservednon-reservednon-reserved
RETURNED_CARDINALITY     
RETURNED_LENGTH     
RETURNED_​OCTET_​LENGTH     
RETURNED_SQLSTATE     
RETURNINGreserved reservedreservedreserved
RETURNSnon-reserved non-reservednon-reservednon-reserved
REVOKEnon-reserved non-reservednon-reservednon-reserved
RIGHTreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
ROLEnon-reserved non-reservednon-reservednon-reserved
ROLLBACKnon-reserved non-reservednon-reservednon-reserved
ROLLUPnon-reserved non-reservednon-reservednon-reserved
ROOTPARTITIONnon-reserved non-reservednon-reservednon-reserved
ROUTINEnon-reserved non-reservednon-reservednon-reserved
ROUTINESnon-reserved non-reservednon-reservednon-reserved
ROUTINE_CATALOG     
ROUTINE_NAME     
ROUTINE_SCHEMA     
ROWnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
ROWNUM reservedreservedreservedreserved
ROWSnon-reserved non-reservednon-reservednon-reserved
ROWTYPE non-reservednon-reservednon-reservednon-reserved
ROW_COUNT     
ROW_NUMBER     
RULEnon-reserved non-reservednon-reservednon-reserved
RUNNING     
SAVEPOINTnon-reserved non-reservednon-reservednon-reserved
SCALAR     
SCALE     
SCHEMAnon-reserved non-reservednon-reservednon-reserved
SCHEMASnon-reserved non-reservednon-reservednon-reserved
SCHEMA_NAME     
SCOPE     
SCOPE_CATALOG     
SCOPE_NAME     
SCOPE_SCHEMA     
SCROLLnon-reserved non-reservednon-reservednon-reserved
SEARCHnon-reserved non-reservednon-reservednon-reserved
SECONDnon-reserved non-reservednon-reservednon-reserved
SECTION     
SECURITYnon-reserved non-reservednon-reservednon-reserved
SEEK     
SELECTreserved reservedreservedreserved
SELECTIVE     
SELF     
SENSITIVE     
SEPARATOR reservedreservedreservedreserved
SEQUENCEnon-reserved non-reservednon-reservednon-reserved
SEQUENCESnon-reserved non-reservednon-reservednon-reserved
SERIALIZABLEnon-reserved non-reservednon-reservednon-reserved
SERVERnon-reserved non-reservednon-reservednon-reserved
SERVER_NAME     
SESSIONnon-reserved non-reservednon-reservednon-reserved
SESSION_USERreserved reservedreservedreserved
SETnon-reserved non-reservednon-reservednon-reserved
SETOFnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
SETSnon-reserved non-reservednon-reservednon-reserved
SHARD_COUNT non-reservednon-reservednon-reservednon-reserved
SHAREnon-reserved non-reservednon-reservednon-reserved
SHOWnon-reserved non-reservednon-reservednon-reserved
SIMILARreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
SIMPLEnon-reserved non-reservednon-reservednon-reserved
SIN     
SINH     
SIZE     
SKIPnon-reserved non-reservednon-reservednon-reserved
SMALLINTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
SNAPSHOTnon-reserved non-reservednon-reservednon-reserved
SOMEreserved reservedreservedreserved
SOURCE     
SPACE     
SPECIFIC     
SPECIFICTYPE     
SPECIFIC_NAME     
SPLIT non-reservednon-reservednon-reservednon-reserved
SQLnon-reserved non-reservednon-reservednon-reserved
SQLCODE     
SQLERROR     
SQLEXCEPTION     
SQLSTATE     
SQLWARNING     
SQRT     
STABLEnon-reserved non-reservednon-reservednon-reserved
STANDALONEnon-reserved non-reservednon-reservednon-reserved
STARTnon-reserved non-reservednon-reservednon-reserved
STATE     
STATEMENTnon-reserved non-reservednon-reservednon-reserved
STATIC     
STATISTICSnon-reserved non-reservednon-reservednon-reserved
STDDEV_POP     
STDDEV_SAMP     
STDINnon-reserved non-reservednon-reservednon-reserved
STDOUTnon-reserved non-reservednon-reservednon-reserved
STORAGEnon-reserved non-reservednon-reservednon-reserved
STOREDnon-reserved non-reservednon-reservednon-reserved
STRICTnon-reserved non-reservednon-reservednon-reserved
STRING     
STRIPnon-reserved non-reservednon-reservednon-reserved
STRUCTURE     
STYLE     
SUBCLASS_ORIGIN     
SUBMULTISET     
SUBPARTITION non-reservednon-reservednon-reservednon-reserved
SUBSCRIPTIONnon-reserved non-reservednon-reservednon-reserved
SUBSET     
SUBSTRINGnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
SUBSTRING_REGEX     
SUCCEEDS     
SUM     
SUPPORTnon-reserved non-reservednon-reservednon-reserved
SYMMETRICreserved reservedreservedreserved
SYSDATE reservedreservedreservedreserved
SYSIDnon-reserved non-reservednon-reservednon-reserved
SYSTEMnon-reserved non-reservednon-reservednon-reserved
SYSTEM_TIME     
SYSTEM_USER     
SYSTIMESTAMP reservedreservedreservedreserved
T     
TABLEreserved reservedreservedreserved
TABLESnon-reserved non-reservednon-reservednon-reserved
TABLESAMPLEreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
TABLESPACEnon-reserved non-reservednon-reservednon-reserved
TABLE_NAME     
TAN     
TANH     
TEMPnon-reserved non-reservednon-reservednon-reserved
TEMPLATEnon-reserved non-reservednon-reservednon-reserved
TEMPORARYnon-reserved non-reservednon-reservednon-reserved
TEXTnon-reserved non-reservednon-reservednon-reserved
THENreserved reservedreservedreserved
THROUGH     
TIESnon-reserved non-reservednon-reservednon-reserved
TIMEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
TIMESTAMPnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
TIMEZONE_HOUR     
TIMEZONE_MINUTE     
TOreserved reservedreservedreserved
TOKEN     
TOP_LEVEL_COUNT     
TRAILINGreserved reservedreservedreserved
TRANSACTIONnon-reserved non-reservednon-reservednon-reserved
TRANSACTIONS_​COMMITTED     
TRANSACTIONS_​ROLLED_​BACK     
TRANSACTION_ACTIVE     
TRANSFORMnon-reserved non-reservednon-reservednon-reserved
TRANSFORMS     
TRANSLATE     
TRANSLATE_REGEX     
TRANSLATION     
TREATnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
TRIGGERnon-reserved non-reservednon-reservednon-reserved
TRIGGER_CATALOG     
TRIGGER_NAME     
TRIGGER_SCHEMA     
TRIMnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
TRIM_ARRAY     
TRUEreserved reservedreservedreserved
TRUNCATEnon-reserved non-reservednon-reservednon-reserved
TRUSTEDnon-reserved non-reservednon-reservednon-reserved
TYPEnon-reserved non-reservednon-reservednon-reserved
TYPESnon-reserved non-reservednon-reservednon-reserved
UESCAPEnon-reserved non-reservednon-reservednon-reserved
UNBOUNDEDreserved reservedreservedreserved
UNCOMMITTEDnon-reserved non-reservednon-reservednon-reserved
UNCONDITIONAL     
UNDER     
UNENCRYPTEDnon-reserved non-reservednon-reservednon-reserved
UNIONreserved reservedreservedreserved
UNIQUEreserved reservedreservedreserved
UNKNOWNnon-reserved non-reservednon-reservednon-reserved
UNLINK     
UNLISTENnon-reserved non-reservednon-reservednon-reserved
UNLOGGEDnon-reserved non-reservednon-reservednon-reserved
UNMATCHED     
UNNAMED     
UNNEST     
UNTILnon-reserved non-reservednon-reservednon-reserved
UNTYPED     
UPDATEnon-reserved non-reservednon-reservednon-reserved
UPPER     
URI     
USAGE     
USERreserved reservedreservedreserved
USER_​DEFINED_​TYPE_​CATALOG     
USER_​DEFINED_​TYPE_​CODE     
USER_​DEFINED_​TYPE_​NAME     
USER_​DEFINED_​TYPE_​SCHEMA     
USINGreserved reservedreservedreserved
UTF16     
UTF32     
UTF8     
VACUUMnon-reserved non-reservednon-reservednon-reserved
VALIDnon-reserved non-reservednon-reservednon-reserved
VALIDATEnon-reserved non-reservednon-reservednon-reserved
VALIDATORnon-reserved non-reservednon-reservednon-reserved
VALUEnon-reserved non-reservednon-reservednon-reserved
VALUESnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
VALUE_OF     
VARBINARY     
VARCHARnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
VARIADICreserved reservedreservedreserved
VARYINGnon-reserved non-reservednon-reservednon-reserved
VAR_POP     
VAR_SAMP     
VERBOSEreserved (can be function or type) reserved (can be function or type)reserved (can be function or type)reserved (can be function or type)
VERSIONnon-reserved non-reservednon-reservednon-reserved
VERSIONING     
VIEWnon-reserved non-reservednon-reservednon-reserved
VIEWSnon-reserved non-reservednon-reservednon-reserved
VOLATILEnon-reserved non-reservednon-reservednon-reserved
WHENreserved reservedreservedreserved
WHENEVER     
WHEREreserved reservedreservedreserved
WHILE non-reservednon-reservednon-reservednon-reserved
WHITESPACEnon-reserved non-reservednon-reservednon-reserved
WIDTH_BUCKET     
WINDOWreserved reservedreservedreserved
WITHreserved reservedreservedreserved
WITHINnon-reserved non-reservednon-reservednon-reserved
WITHOUTnon-reserved non-reservednon-reservednon-reserved
WORKnon-reserved non-reservednon-reservednon-reserved
WRAPPERnon-reserved non-reservednon-reservednon-reserved
WRITABLEnon-reserved non-reservednon-reservednon-reserved
WRITEnon-reserved non-reservednon-reservednon-reserved
XMLnon-reserved non-reservednon-reservednon-reserved
XMLAGG     
XMLATTRIBUTESnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLBINARY     
XMLCAST     
XMLCOMMENT     
XMLCONCATnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLDECLARATION     
XMLDOCUMENT     
XMLELEMENTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLEXISTSnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLFORESTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLITERATE     
XMLNAMESPACESnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLPARSEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLPInon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLQUERY     
XMLROOTnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLSCHEMA     
XMLSERIALIZEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLTABLEnon-reserved (cannot be function or type) non-reserved (cannot be function or type)non-reserved (cannot be function or type)non-reserved (cannot be function or type)
XMLTEXT     
XMLVALIDATE     
YEARnon-reserved non-reservednon-reservednon-reserved
YESnon-reserved non-reservednon-reservednon-reserved
ZONEnon-reserved non-reservednon-reservednon-reserved