Appendix C. SQL Key Words

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.0.0. Background information can be found in Section 4.1.1.

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 PostgreSQL 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 PostgreSQL, 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 PostgreSQL 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 PostgreSQL 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 WordPostgreSQLSQL:2008SQL:2003SQL:1999SQL-92
A non-reservednon-reserved  
ABORTnon-reserved    
ABS reservedreservednon-reserved 
ABSENT non-reserved   
ABSOLUTEnon-reservednon-reservednon-reservedreservedreserved
ACCESSnon-reserved    
ACCORDING non-reserved   
ACTIONnon-reservednon-reservednon-reservedreservedreserved
ADA non-reservednon-reservednon-reservednon-reserved
ADDnon-reservednon-reservednon-reservedreservedreserved
ADMINnon-reservednon-reservednon-reservedreserved 
AFTERnon-reservednon-reservednon-reservedreserved 
AGGREGATEnon-reserved  reserved 
ALIAS   reserved 
ALLreservedreservedreservedreservedreserved
ALLOCATE reservedreservedreservedreserved
ALSOnon-reserved    
ALTERnon-reservedreservedreservedreservedreserved
ALWAYSnon-reservednon-reservednon-reserved  
ANALYSEreserved    
ANALYZEreserved    
ANDreservedreservedreservedreservedreserved
ANYreservedreservedreservedreservedreserved
ARE reservedreservedreservedreserved
ARRAYreservedreservedreservedreserved 
ARRAY_AGG reserved   
ASreservedreservedreservedreservedreserved
ASCreservednon-reservednon-reservedreservedreserved
ASENSITIVE reservedreservednon-reserved 
ASSERTIONnon-reservednon-reservednon-reservedreservedreserved
ASSIGNMENTnon-reservednon-reservednon-reservednon-reserved 
ASYMMETRICreservedreservedreservednon-reserved 
ATnon-reservedreservedreservedreservedreserved
ATOMIC reservedreservednon-reserved 
ATTRIBUTE non-reservednon-reserved  
ATTRIBUTES non-reservednon-reserved  
AUTHORIZATIONreserved (can be function or type)reservedreservedreservedreserved
AVG reservedreservednon-reservedreserved
BACKWARDnon-reserved    
BASE64 non-reservednon-reserved  
BEFOREnon-reservednon-reservednon-reservedreserved 
BEGINnon-reservedreservedreservedreservedreserved
BERNOULLI non-reservednon-reserved  
BETWEENnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
BIGINTnon-reserved (cannot be function or type)reservedreserved  
BINARYreserved (can be function or type)reservedreservedreserved 
BITnon-reserved (cannot be function or type)  reservedreserved
BITVAR   non-reserved 
BIT_LENGTH   non-reservedreserved
BLOB reservedreservedreserved 
BLOCKED non-reservednon-reserved  
BOM non-reserved   
BOOLEANnon-reserved (cannot be function or type)reservedreservedreserved 
BOTHreservedreservedreservedreservedreserved
BREADTH non-reservednon-reservedreserved 
BYnon-reservedreservedreservedreservedreserved
C non-reservednon-reservednon-reservednon-reserved
CACHEnon-reserved    
CALL reservedreservedreserved 
CALLEDnon-reservedreservedreservednon-reserved 
CARDINALITY reservedreservednon-reserved 
CASCADEnon-reservednon-reservednon-reservedreservedreserved
CASCADEDnon-reservedreservedreservedreservedreserved
CASEreservedreservedreservedreservedreserved
CASTreservedreservedreservedreservedreserved
CATALOGnon-reservednon-reservednon-reservedreservedreserved
CATALOG_NAME non-reservednon-reservednon-reservednon-reserved
CEIL reservedreserved  
CEILING reservedreserved  
CHAINnon-reservednon-reservednon-reservednon-reserved 
CHARnon-reserved (cannot be function or type)reservedreservedreservedreserved
CHARACTERnon-reserved (cannot be function or type)reservedreservedreservedreserved
CHARACTERISTICSnon-reservednon-reservednon-reserved  
CHARACTERS non-reservednon-reserved  
CHARACTER_LENGTH reservedreservednon-reservedreserved
CHARACTER_SET_CATALOG non-reservednon-reservednon-reservednon-reserved
CHARACTER_SET_NAME non-reservednon-reservednon-reservednon-reserved
CHARACTER_SET_SCHEMA non-reservednon-reservednon-reservednon-reserved
CHAR_LENGTH reservedreservednon-reservedreserved
CHECKreservedreservedreservedreservedreserved
CHECKED   non-reserved 
CHECKPOINTnon-reserved    
CLASSnon-reserved  reserved 
CLASS_ORIGIN non-reservednon-reservednon-reservednon-reserved
CLOB reservedreservedreserved 
CLOSEnon-reservedreservedreservedreservedreserved
CLUSTERnon-reserved    
COALESCEnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
COBOL non-reservednon-reservednon-reservednon-reserved
COLLATEreservedreservedreservedreservedreserved
COLLATION non-reservednon-reservedreservedreserved
COLLATION_CATALOG non-reservednon-reservednon-reservednon-reserved
COLLATION_NAME non-reservednon-reservednon-reservednon-reserved
COLLATION_SCHEMA non-reservednon-reservednon-reservednon-reserved
COLLECT reservedreserved  
COLUMNreservedreservedreservedreservedreserved
COLUMNS non-reserved   
COLUMN_NAME non-reservednon-reservednon-reservednon-reserved
COMMAND_FUNCTION non-reservednon-reservednon-reservednon-reserved
COMMAND_FUNCTION_CODE non-reservednon-reservednon-reserved 
COMMENTnon-reserved    
COMMENTSnon-reserved    
COMMITnon-reservedreservedreservedreservedreserved
COMMITTEDnon-reservednon-reservednon-reservednon-reservednon-reserved
COMPLETION   reserved 
CONCURRENTLYreserved (can be function or type)    
CONDITION reservedreserved  
CONDITION_NUMBER non-reservednon-reservednon-reservednon-reserved
CONFIGURATIONnon-reserved    
CONNECT reservedreservedreservedreserved
CONNECTIONnon-reservednon-reservednon-reservedreservedreserved
CONNECTION_NAME non-reservednon-reservednon-reservednon-reserved
CONSTRAINTreservedreservedreservedreservedreserved
CONSTRAINTSnon-reservednon-reservednon-reservedreservedreserved
CONSTRAINT_CATALOG non-reservednon-reservednon-reservednon-reserved
CONSTRAINT_NAME non-reservednon-reservednon-reservednon-reserved
CONSTRAINT_SCHEMA non-reservednon-reservednon-reservednon-reserved
CONSTRUCTOR non-reservednon-reservedreserved 
CONTAINS non-reservednon-reservednon-reserved 
CONTENTnon-reservednon-reservednon-reserved  
CONTINUEnon-reservednon-reservednon-reservedreservedreserved
CONTROL non-reservednon-reserved  
CONVERSIONnon-reserved    
CONVERT reservedreservednon-reservedreserved
COPYnon-reserved    
CORR reservedreserved  
CORRESPONDING reservedreservedreservedreserved
COSTnon-reserved    
COUNT reservedreservednon-reservedreserved
COVAR_POP reservedreserved  
COVAR_SAMP reservedreserved  
CREATEreservedreservedreservedreservedreserved
CREATEDBnon-reserved    
CREATEROLEnon-reserved    
CREATEUSERnon-reserved    
CROSSreserved (can be function or type)reservedreservedreservedreserved
CSVnon-reserved    
CUBE reservedreservedreserved 
CUME_DIST reservedreserved  
CURRENTnon-reservedreservedreservedreservedreserved
CURRENT_CATALOGreservedreserved   
CURRENT_DATEreservedreservedreservedreservedreserved
CURRENT_DEFAULT_TRANSFORM_GROUP reservedreserved  
CURRENT_PATH reservedreservedreserved 
CURRENT_ROLEreservedreservedreservedreserved 
CURRENT_SCHEMAreserved (can be function or type)reserved   
CURRENT_TIMEreservedreservedreservedreservedreserved
CURRENT_TIMESTAMPreservedreservedreservedreservedreserved
CURRENT_TRANSFORM_GROUP_FOR_TYPE reservedreserved  
CURRENT_USERreservedreservedreservedreservedreserved
CURSORnon-reservedreservedreservedreservedreserved
CURSOR_NAME non-reservednon-reservednon-reservednon-reserved
CYCLEnon-reservedreservedreservedreserved 
DATAnon-reservednon-reservednon-reservedreservednon-reserved
DATABASEnon-reserved    
DATALINK reservedreserved  
DATE reservedreservedreservedreserved
DATETIME_INTERVAL_CODE non-reservednon-reservednon-reservednon-reserved
DATETIME_INTERVAL_PRECISION non-reservednon-reservednon-reservednon-reserved
DAYnon-reservedreservedreservedreservedreserved
DB non-reservednon-reserved  
DEALLOCATEnon-reservedreservedreservedreservedreserved
DECnon-reserved (cannot be function or type)reservedreservedreservedreserved
DECIMALnon-reserved (cannot be function or type)reservedreservedreservedreserved
DECLAREnon-reservedreservedreservedreservedreserved
DEFAULTreservedreservedreservedreservedreserved
DEFAULTSnon-reservednon-reservednon-reserved  
DEFERRABLEreservednon-reservednon-reservedreservedreserved
DEFERREDnon-reservednon-reservednon-reservedreservedreserved
DEFINED non-reservednon-reservednon-reserved 
DEFINERnon-reservednon-reservednon-reservednon-reserved 
DEGREE non-reservednon-reserved  
DELETEnon-reservedreservedreservedreservedreserved
DELIMITERnon-reserved    
DELIMITERSnon-reserved    
DENSE_RANK reservedreserved  
DEPTH non-reservednon-reservedreserved 
DEREF reservedreservedreserved 
DERIVED non-reservednon-reserved  
DESCreservednon-reservednon-reservedreservedreserved
DESCRIBE reservedreservedreservedreserved
DESCRIPTOR non-reservednon-reservedreservedreserved
DESTROY   reserved 
DESTRUCTOR   reserved 
DETERMINISTIC reservedreservedreserved 
DIAGNOSTICS non-reservednon-reservedreservedreserved
DICTIONARYnon-reserved  reserved 
DISABLEnon-reserved    
DISCARDnon-reserved    
DISCONNECT reservedreservedreservedreserved
DISPATCH non-reservednon-reservednon-reserved 
DISTINCTreservedreservedreservedreservedreserved
DLNEWCOPY reservedreserved  
DLPREVIOUSCOPY reservedreserved  
DLURLCOMPLETE reservedreserved  
DLURLCOMPLETEONLY reservedreserved  
DLURLCOMPLETEWRITE reservedreserved  
DLURLPATH reservedreserved  
DLURLPATHONLY reservedreserved  
DLURLPATHWRITE reservedreserved  
DLURLSCHEME reservedreserved  
DLURLSERVER reservedreserved  
DLVALUE reservedreserved  
DOreserved    
DOCUMENTnon-reservednon-reservednon-reserved  
DOMAINnon-reservednon-reservednon-reservedreservedreserved
DOUBLEnon-reservedreservedreservedreservedreserved
DROPnon-reservedreservedreservedreservedreserved
DYNAMIC reservedreservedreserved 
DYNAMIC_FUNCTION non-reservednon-reservednon-reservednon-reserved
DYNAMIC_FUNCTION_CODE non-reservednon-reservednon-reserved 
EACHnon-reservedreservedreservedreserved 
ELEMENT reservedreserved  
ELSEreservedreservedreservedreservedreserved
EMPTY non-reserved   
ENABLEnon-reserved    
ENCODINGnon-reservednon-reserved   
ENCRYPTEDnon-reserved    
ENDreservedreservedreservedreservedreserved
END-EXEC reservedreservedreservedreserved
ENUMnon-reserved    
EQUALS non-reservednon-reservedreserved 
ESCAPEnon-reservedreservedreservedreservedreserved
EVERY reservedreservedreserved 
EXCEPTreservedreservedreservedreservedreserved
EXCEPTION  non-reservedreservedreserved
EXCLUDEnon-reservednon-reservednon-reserved  
EXCLUDINGnon-reservednon-reservednon-reserved  
EXCLUSIVEnon-reserved    
EXEC reservedreservedreservedreserved
EXECUTEnon-reservedreservedreservedreservedreserved
EXISTING   non-reserved 
EXISTSnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
EXP reservedreserved  
EXPLAINnon-reserved    
EXTERNALnon-reservedreservedreservedreservedreserved
EXTRACTnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
FALSEreservedreservedreservedreservedreserved
FAMILYnon-reserved    
FETCHreservedreservedreservedreservedreserved
FILE non-reservednon-reserved  
FILTER reservedreserved  
FINAL non-reservednon-reservednon-reserved 
FIRSTnon-reservednon-reservednon-reservedreservedreserved
FIRST_VALUE reserved   
FLAG non-reserved   
FLOATnon-reserved (cannot be function or type)reservedreservedreservedreserved
FLOOR reservedreserved  
FOLLOWINGnon-reservednon-reservednon-reserved  
FORreservedreservedreservedreservedreserved
FORCEnon-reserved    
FOREIGNreservedreservedreservedreservedreserved
FORTRAN non-reservednon-reservednon-reservednon-reserved
FORWARDnon-reserved    
FOUND non-reservednon-reservedreservedreserved
FREE reservedreservedreserved 
FREEZEreserved (can be function or type)    
FROMreservedreservedreservedreservedreserved
FS non-reservednon-reserved  
FULLreserved (can be function or type)reservedreservedreservedreserved
FUNCTIONnon-reservedreservedreservedreserved 
FUNCTIONSnon-reserved    
FUSION reservedreserved  
G non-reservednon-reservednon-reserved 
GENERAL non-reservednon-reservedreserved 
GENERATED non-reservednon-reservednon-reserved 
GET reservedreservedreservedreserved
GLOBALnon-reservedreservedreservedreservedreserved
GO non-reservednon-reservedreservedreserved
GOTO non-reservednon-reservedreservedreserved
GRANTreservedreservedreservedreservedreserved
GRANTEDnon-reservednon-reservednon-reservednon-reserved 
GREATESTnon-reserved (cannot be function or type)    
GROUPreservedreservedreservedreservedreserved
GROUPING reservedreservedreserved 
HANDLERnon-reserved    
HAVINGreservedreservedreservedreservedreserved
HEADERnon-reserved    
HEX non-reservednon-reserved  
HIERARCHY non-reservednon-reservednon-reserved 
HOLDnon-reservedreservedreservednon-reserved 
HOST   reserved 
HOURnon-reservedreservedreservedreservedreserved
ID non-reserved   
IDENTITYnon-reservedreservedreservedreservedreserved
IFnon-reserved    
IGNORE non-reserved reserved 
ILIKEreserved (can be function or type)    
IMMEDIATEnon-reservednon-reservednon-reservedreservedreserved
IMMUTABLEnon-reserved    
IMPLEMENTATION non-reservednon-reservednon-reserved 
IMPLICITnon-reserved    
IMPORT reservedreserved  
INreservedreservedreservedreservedreserved
INCLUDINGnon-reservednon-reservednon-reserved  
INCREMENTnon-reservednon-reservednon-reserved  
INDENT non-reserved   
INDEXnon-reserved    
INDEXESnon-reserved    
INDICATOR reservedreservedreservedreserved
INFIX   non-reserved 
INHERITnon-reserved    
INHERITSnon-reserved    
INITIALIZE   reserved 
INITIALLYreservednon-reservednon-reservedreservedreserved
INLINEnon-reserved    
INNERreserved (can be function or type)reservedreservedreservedreserved
INOUTnon-reserved (cannot be function or type)reservedreservedreserved 
INPUTnon-reservednon-reservednon-reservedreservedreserved
INSENSITIVEnon-reservedreservedreservednon-reservedreserved
INSERTnon-reservedreservedreservedreservedreserved
INSTANCE non-reservednon-reservednon-reserved 
INSTANTIABLE non-reservednon-reservednon-reserved 
INSTEADnon-reservednon-reserved   
INTnon-reserved (cannot be function or type)reservedreservedreservedreserved
INTEGERnon-reserved (cannot be function or type)reservedreservedreservedreserved
INTEGRITY non-reservednon-reserved  
INTERSECTreservedreservedreservedreservedreserved
INTERSECTION reservedreserved  
INTERVALnon-reserved (cannot be function or type)reservedreservedreservedreserved
INTOreservedreservedreservedreservedreserved
INVOKERnon-reservednon-reservednon-reservednon-reserved 
ISreserved (can be function or type)reservedreservedreservedreserved
ISNULLreserved (can be function or type)    
ISOLATIONnon-reservednon-reservednon-reservedreservedreserved
ITERATE   reserved 
JOINreserved (can be function or type)reservedreservedreservedreserved
K non-reservednon-reservednon-reserved 
KEYnon-reservednon-reservednon-reservedreservedreserved
KEY_MEMBER non-reservednon-reservednon-reserved 
KEY_TYPE non-reservednon-reservednon-reserved 
LAG reserved   
LANGUAGEnon-reservedreservedreservedreservedreserved
LARGEnon-reservedreservedreservedreserved 
LASTnon-reservednon-reservednon-reservedreservedreserved
LAST_VALUE reserved   
LATERAL reservedreservedreserved 
LC_COLLATEnon-reserved    
LC_CTYPEnon-reserved    
LEAD reserved   
LEADINGreservedreservedreservedreservedreserved
LEASTnon-reserved (cannot be function or type)    
LEFTreserved (can be function or type)reservedreservedreservedreserved
LENGTH non-reservednon-reservednon-reservednon-reserved
LESS   reserved 
LEVELnon-reservednon-reservednon-reservedreservedreserved
LIBRARY non-reservednon-reserved  
LIKEreserved (can be function or type)reservedreservedreservedreserved
LIKE_REGEX reserved   
LIMITreservednon-reservednon-reservedreserved 
LINK non-reservednon-reserved  
LISTENnon-reserved    
LN reservedreserved  
LOADnon-reserved    
LOCALnon-reservedreservedreservedreservedreserved
LOCALTIMEreservedreservedreservedreserved 
LOCALTIMESTAMPreservedreservedreservedreserved 
LOCATIONnon-reservednon-reserved   
LOCATOR non-reservednon-reservedreserved 
LOCKnon-reserved    
LOGINnon-reserved    
LOWER reservedreservednon-reservedreserved
M non-reservednon-reservednon-reserved 
MAP non-reservednon-reservedreserved 
MAPPINGnon-reservednon-reservednon-reserved  
MATCHnon-reservedreservedreservedreservedreserved
MATCHED non-reservednon-reserved  
MAX reservedreservednon-reservedreserved
MAXVALUEnon-reservednon-reservednon-reserved  
MAX_CARDINALITY reserved   
MEMBER reservedreserved  
MERGE reservedreserved  
MESSAGE_LENGTH non-reservednon-reservednon-reservednon-reserved
MESSAGE_OCTET_LENGTH non-reservednon-reservednon-reservednon-reserved
MESSAGE_TEXT non-reservednon-reservednon-reservednon-reserved
METHOD reservedreservednon-reserved 
MIN reservedreservednon-reservedreserved
MINUTEnon-reservedreservedreservedreservedreserved
MINVALUEnon-reservednon-reservednon-reserved  
MOD reservedreservednon-reserved 
MODEnon-reserved    
MODIFIES reservedreservedreserved 
MODIFY   reserved 
MODULE reservedreservedreservedreserved
MONTHnon-reservedreservedreservedreservedreserved
MORE non-reservednon-reservednon-reservednon-reserved
MOVEnon-reserved    
MULTISET reservedreserved  
MUMPS non-reservednon-reservednon-reservednon-reserved
NAMEnon-reservednon-reservednon-reservednon-reservednon-reserved
NAMESnon-reservednon-reservednon-reservedreservedreserved
NAMESPACE non-reserved   
NATIONALnon-reserved (cannot be function or type)reservedreservedreservedreserved
NATURALreserved (can be function or type)reservedreservedreservedreserved
NCHARnon-reserved (cannot be function or type)reservedreservedreservedreserved
NCLOB reservedreservedreserved 
NESTING non-reservednon-reserved  
NEW reservedreservedreserved 
NEXTnon-reservednon-reservednon-reservedreservedreserved
NFC non-reserved   
NFD non-reserved   
NFKC non-reserved   
NFKD non-reserved   
NIL non-reserved   
NOnon-reservedreservedreservedreservedreserved
NOCREATEDBnon-reserved    
NOCREATEROLEnon-reserved    
NOCREATEUSERnon-reserved    
NOINHERITnon-reserved    
NOLOGINnon-reserved    
NONEnon-reserved (cannot be function or type)reservedreservedreserved 
NORMALIZE reservedreserved  
NORMALIZED non-reservednon-reserved  
NOSUPERUSERnon-reserved    
NOTreservedreservedreservedreservedreserved
NOTHINGnon-reserved    
NOTIFYnon-reserved    
NOTNULLreserved (can be function or type)    
NOWAITnon-reserved    
NTH_VALUE reserved   
NTILE reserved   
NULLreservedreservedreservedreservedreserved
NULLABLE non-reservednon-reservednon-reservednon-reserved
NULLIFnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
NULLSnon-reservednon-reservednon-reserved  
NUMBER non-reservednon-reservednon-reservednon-reserved
NUMERICnon-reserved (cannot be function or type)reservedreservedreservedreserved
OBJECTnon-reservednon-reservednon-reservedreserved 
OCCURRENCES_REGEX reserved   
OCTETS non-reservednon-reserved  
OCTET_LENGTH reservedreservednon-reservedreserved
OFnon-reservedreservedreservedreservedreserved
OFFreservednon-reservednon-reservedreserved 
OFFSETreservedreserved   
OIDSnon-reserved    
OLD reservedreservedreserved 
ONreservedreservedreservedreservedreserved
ONLYreservedreservedreservedreservedreserved
OPEN reservedreservedreservedreserved
OPERATION   reserved 
OPERATORnon-reserved    
OPTIONnon-reservednon-reservednon-reservedreservedreserved
OPTIONSnon-reservednon-reservednon-reservednon-reserved 
ORreservedreservedreservedreservedreserved
ORDERreservedreservedreservedreservedreserved
ORDERING non-reservednon-reserved  
ORDINALITY non-reservednon-reservedreserved 
OTHERS non-reservednon-reserved  
OUTnon-reserved (cannot be function or type)reservedreservedreserved 
OUTERreserved (can be function or type)reservedreservedreservedreserved
OUTPUT non-reservednon-reservedreservedreserved
OVERreserved (can be function or type)reservedreserved  
OVERLAPSreserved (can be function or type)reservedreservednon-reservedreserved
OVERLAYnon-reserved (cannot be function or type)reservedreservednon-reserved 
OVERRIDING non-reservednon-reservednon-reserved 
OWNEDnon-reserved    
OWNERnon-reserved    
P non-reserved   
PAD non-reservednon-reservedreservedreserved
PARAMETER reservedreservedreserved 
PARAMETERS   reserved 
PARAMETER_MODE non-reservednon-reservednon-reserved 
PARAMETER_NAME non-reservednon-reservednon-reserved 
PARAMETER_ORDINAL_POSITION non-reservednon-reservednon-reserved 
PARAMETER_SPECIFIC_CATALOG non-reservednon-reservednon-reserved 
PARAMETER_SPECIFIC_NAME non-reservednon-reservednon-reserved 
PARAMETER_SPECIFIC_SCHEMA non-reservednon-reservednon-reserved 
PARSERnon-reserved    
PARTIALnon-reservednon-reservednon-reservedreservedreserved
PARTITIONnon-reservedreservedreserved  
PASCAL non-reservednon-reservednon-reservednon-reserved
PASSING non-reserved   
PASSTHROUGH non-reservednon-reserved  
PASSWORDnon-reserved    
PATH non-reservednon-reservedreserved 
PERCENTILE_CONT reservedreserved  
PERCENTILE_DISC reservedreserved  
PERCENT_RANK reservedreserved  
PERMISSION non-reservednon-reserved  
PLACINGreservednon-reservednon-reserved  
PLANSnon-reserved    
PLI non-reservednon-reservednon-reservednon-reserved
POSITIONnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
POSITION_REGEX reserved   
POSTFIX   reserved 
POWER reservedreserved  
PRECEDINGnon-reservednon-reservednon-reserved  
PRECISIONnon-reserved (cannot be function or type)reservedreservedreservedreserved
PREFIX   reserved 
PREORDER   reserved 
PREPAREnon-reservedreservedreservedreservedreserved
PREPAREDnon-reserved    
PRESERVEnon-reservednon-reservednon-reservedreservedreserved
PRIMARYreservedreservedreservedreservedreserved
PRIORnon-reservednon-reservednon-reservedreservedreserved
PRIVILEGESnon-reservednon-reservednon-reservedreservedreserved
PROCEDURALnon-reserved    
PROCEDUREnon-reservedreservedreservedreservedreserved
PUBLIC non-reservednon-reservedreservedreserved
QUOTEnon-reserved    
RANGEnon-reservedreservedreserved  
RANK reservedreserved  
READnon-reservednon-reservednon-reservedreservedreserved
READS reservedreservedreserved 
REALnon-reserved (cannot be function or type)reservedreservedreservedreserved
REASSIGNnon-reserved    
RECHECKnon-reserved    
RECOVERY non-reservednon-reserved  
RECURSIVEnon-reservedreservedreservedreserved 
REF reservedreservedreserved 
REFERENCESreservedreservedreservedreservedreserved
REFERENCING reservedreservedreserved 
REGR_AVGX reservedreserved  
REGR_AVGY reservedreserved  
REGR_COUNT reservedreserved  
REGR_INTERCEPT reservedreserved  
REGR_R2 reservedreserved  
REGR_SLOPE reservedreserved  
REGR_SXX reservedreserved  
REGR_SXY reservedreserved  
REGR_SYY reservedreserved  
REINDEXnon-reserved    
RELATIVEnon-reservednon-reservednon-reservedreservedreserved
RELEASEnon-reservedreservedreserved  
RENAMEnon-reserved    
REPEATABLEnon-reservednon-reservednon-reservednon-reservednon-reserved
REPLACEnon-reserved    
REPLICAnon-reserved    
REQUIRING non-reservednon-reserved  
RESETnon-reserved    
RESPECT non-reserved   
RESTARTnon-reservednon-reservednon-reserved  
RESTORE non-reservednon-reserved  
RESTRICTnon-reservednon-reservednon-reservedreservedreserved
RESULT reservedreservedreserved 
RETURN reservedreservedreserved 
RETURNED_CARDINALITY non-reservednon-reserved  
RETURNED_LENGTH non-reservednon-reservednon-reservednon-reserved
RETURNED_OCTET_LENGTH non-reservednon-reservednon-reservednon-reserved
RETURNED_SQLSTATE non-reservednon-reservednon-reservednon-reserved
RETURNINGreservednon-reserved   
RETURNSnon-reservedreservedreservedreserved 
REVOKEnon-reservedreservedreservedreservedreserved
RIGHTreserved (can be function or type)reservedreservedreservedreserved
ROLEnon-reservednon-reservednon-reservedreserved 
ROLLBACKnon-reservedreservedreservedreservedreserved
ROLLUP reservedreservedreserved 
ROUTINE non-reservednon-reservedreserved 
ROUTINE_CATALOG non-reservednon-reservednon-reserved 
ROUTINE_NAME non-reservednon-reservednon-reserved 
ROUTINE_SCHEMA non-reservednon-reservednon-reserved 
ROWnon-reserved (cannot be function or type)reservedreservedreserved 
ROWSnon-reservedreservedreservedreservedreserved
ROW_COUNT non-reservednon-reservednon-reservednon-reserved
ROW_NUMBER reservedreserved  
RULEnon-reserved    
SAVEPOINTnon-reservedreservedreservedreserved 
SCALE non-reservednon-reservednon-reservednon-reserved
SCHEMAnon-reservednon-reservednon-reservedreservedreserved
SCHEMA_NAME non-reservednon-reservednon-reservednon-reserved
SCOPE reservedreservedreserved 
SCOPE_CATALOG non-reservednon-reserved  
SCOPE_NAME non-reservednon-reserved  
SCOPE_SCHEMA non-reservednon-reserved  
SCROLLnon-reservedreservedreservedreservedreserved
SEARCHnon-reservedreservedreservedreserved 
SECONDnon-reservedreservedreservedreservedreserved
SECTION non-reservednon-reservedreservedreserved
SECURITYnon-reservednon-reservednon-reservednon-reserved 
SELECTreservedreservedreservedreservedreserved
SELECTIVE non-reservednon-reserved  
SELF non-reservednon-reservednon-reserved 
SENSITIVE reservedreservednon-reserved 
SEQUENCEnon-reservednon-reservednon-reservedreserved 
SEQUENCESnon-reserved    
SERIALIZABLEnon-reservednon-reservednon-reservednon-reservednon-reserved
SERVERnon-reservednon-reservednon-reserved  
SERVER_NAME non-reservednon-reservednon-reservednon-reserved
SESSIONnon-reservednon-reservednon-reservedreservedreserved
SESSION_USERreservedreservedreservedreservedreserved
SETnon-reservedreservedreservedreservedreserved
SETOFnon-reserved (cannot be function or type)    
SETS non-reservednon-reservedreserved 
SHAREnon-reserved    
SHOWnon-reserved    
SIMILARreserved (can be function or type)reservedreservednon-reserved 
SIMPLEnon-reservednon-reservednon-reservednon-reserved 
SIZE non-reservednon-reservedreservedreserved
SMALLINTnon-reserved (cannot be function or type)reservedreservedreservedreserved
SOMEreservedreservedreservedreservedreserved
SOURCE non-reservednon-reservednon-reserved 
SPACE non-reservednon-reservedreservedreserved
SPECIFIC reservedreservedreserved 
SPECIFICTYPE reservedreservedreserved 
SPECIFIC_NAME non-reservednon-reservednon-reserved 
SQL reservedreservedreservedreserved
SQLCODE    reserved
SQLERROR    reserved
SQLEXCEPTION reservedreservedreserved 
SQLSTATE reservedreservedreservedreserved
SQLWARNING reservedreservedreserved 
SQRT reservedreserved  
STABLEnon-reserved    
STANDALONEnon-reservednon-reservednon-reserved  
STARTnon-reservedreservedreservedreserved 
STATE non-reservednon-reservedreserved 
STATEMENTnon-reservednon-reservednon-reservedreserved 
STATIC reservedreservedreserved 
STATISTICSnon-reserved    
STDDEV_POP reservedreserved  
STDDEV_SAMP reservedreserved  
STDINnon-reserved    
STDOUTnon-reserved    
STORAGEnon-reserved    
STRICTnon-reserved    
STRIPnon-reservednon-reservednon-reserved  
STRUCTURE non-reservednon-reservedreserved 
STYLE non-reservednon-reservednon-reserved 
SUBCLASS_ORIGIN non-reservednon-reservednon-reservednon-reserved
SUBLIST   non-reserved 
SUBMULTISET reservedreserved  
SUBSTRINGnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
SUBSTRING_REGEX reserved   
SUM reservedreservednon-reservedreserved
SUPERUSERnon-reserved    
SYMMETRICreservedreservedreservednon-reserved 
SYSIDnon-reserved    
SYSTEMnon-reservedreservedreservednon-reserved 
SYSTEM_USER reservedreservedreservedreserved
T non-reserved   
TABLEreservedreservedreservedreservedreserved
TABLESnon-reserved    
TABLESAMPLE reservedreserved  
TABLESPACEnon-reserved    
TABLE_NAME non-reservednon-reservednon-reservednon-reserved
TEMPnon-reserved    
TEMPLATEnon-reserved    
TEMPORARYnon-reservednon-reservednon-reservedreservedreserved
TERMINATE   reserved 
TEXTnon-reserved    
THAN   reserved 
THENreservedreservedreservedreservedreserved
TIES non-reservednon-reserved  
TIMEnon-reserved (cannot be function or type)reservedreservedreservedreserved
TIMESTAMPnon-reserved (cannot be function or type)reservedreservedreservedreserved
TIMEZONE_HOUR reservedreservedreservedreserved
TIMEZONE_MINUTE reservedreservedreservedreserved
TOreservedreservedreservedreservedreserved
TOKEN non-reservednon-reserved  
TOP_LEVEL_COUNT non-reservednon-reserved  
TRAILINGreservedreservedreservedreservedreserved
TRANSACTIONnon-reservednon-reservednon-reservedreservedreserved
TRANSACTIONS_COMMITTED non-reservednon-reservednon-reserved 
TRANSACTIONS_ROLLED_BACK non-reservednon-reservednon-reserved 
TRANSACTION_ACTIVE non-reservednon-reservednon-reserved 
TRANSFORM non-reservednon-reservednon-reserved 
TRANSFORMS non-reservednon-reservednon-reserved 
TRANSLATE reservedreservednon-reservedreserved
TRANSLATE_REGEX reserved   
TRANSLATION reservedreservedreservedreserved
TREATnon-reserved (cannot be function or type)reservedreservedreserved 
TRIGGERnon-reservedreservedreservedreserved 
TRIGGER_CATALOG non-reservednon-reservednon-reserved 
TRIGGER_NAME non-reservednon-reservednon-reserved 
TRIGGER_SCHEMA non-reservednon-reservednon-reserved 
TRIMnon-reserved (cannot be function or type)reservedreservednon-reservedreserved
TRIM_ARRAY reserved   
TRUEreservedreservedreservedreservedreserved
TRUNCATEnon-reservedreserved   
TRUSTEDnon-reserved    
TYPEnon-reservednon-reservednon-reservednon-reservednon-reserved
UESCAPE reservedreserved  
UNBOUNDEDnon-reservednon-reservednon-reserved  
UNCOMMITTEDnon-reservednon-reservednon-reservednon-reservednon-reserved
UNDER non-reservednon-reservedreserved 
UNENCRYPTEDnon-reserved    
UNIONreservedreservedreservedreservedreserved
UNIQUEreservedreservedreservedreservedreserved
UNKNOWNnon-reservedreservedreservedreservedreserved
UNLINK non-reservednon-reserved  
UNLISTENnon-reserved    
UNNAMED non-reservednon-reservednon-reservednon-reserved
UNNEST reservedreservedreserved 
UNTILnon-reserved    
UNTYPED non-reserved   
UPDATEnon-reservedreservedreservedreservedreserved
UPPER reservedreservednon-reservedreserved
URI non-reserved   
USAGE non-reservednon-reservedreservedreserved
USERreservedreservedreservedreservedreserved
USER_DEFINED_TYPE_CATALOG non-reservednon-reservednon-reserved 
USER_DEFINED_TYPE_CODE non-reservednon-reserved  
USER_DEFINED_TYPE_NAME non-reservednon-reservednon-reserved 
USER_DEFINED_TYPE_SCHEMA non-reservednon-reservednon-reserved 
USINGreservedreservedreservedreservedreserved
VACUUMnon-reserved    
VALIDnon-reservednon-reserved   
VALIDATORnon-reserved    
VALUEnon-reservedreservedreservedreservedreserved
VALUESnon-reserved (cannot be function or type)reservedreservedreservedreserved
VARBINARY reserved   
VARCHARnon-reserved (cannot be function or type)reservedreservedreservedreserved
VARIABLE   reserved 
VARIADICreserved    
VARYINGnon-reservedreservedreservedreservedreserved
VAR_POP reservedreserved  
VAR_SAMP reservedreserved  
VERBOSEreserved (can be function or type)    
VERSIONnon-reservednon-reservednon-reserved  
VIEWnon-reservednon-reservednon-reservedreservedreserved
VOLATILEnon-reserved    
WHENreservedreservedreservedreservedreserved
WHENEVER reservedreservedreservedreserved
WHEREreservedreservedreservedreservedreserved
WHITESPACEnon-reservednon-reservednon-reserved  
WIDTH_BUCKET reservedreserved  
WINDOWreservedreservedreserved  
WITHreservedreservedreservedreservedreserved
WITHIN reservedreserved  
WITHOUTnon-reservedreservedreservedreserved 
WORKnon-reservednon-reservednon-reservedreservedreserved
WRAPPERnon-reservednon-reservednon-reserved  
WRITEnon-reservednon-reservednon-reservedreservedreserved
XMLnon-reservedreservedreserved  
XMLAGG reservedreserved  
XMLATTRIBUTESnon-reserved (cannot be function or type)reservedreserved  
XMLBINARY reservedreserved  
XMLCAST reserved   
XMLCOMMENT reservedreserved  
XMLCONCATnon-reserved (cannot be function or type)reservedreserved  
XMLDECLARATION non-reserved   
XMLDOCUMENT reserved   
XMLELEMENTnon-reserved (cannot be function or type)reservedreserved  
XMLEXISTS reserved   
XMLFORESTnon-reserved (cannot be function or type)reservedreserved  
XMLITERATE reserved   
XMLNAMESPACES reservedreserved  
XMLPARSEnon-reserved (cannot be function or type)reservedreserved  
XMLPInon-reserved (cannot be function or type)reservedreserved  
XMLQUERY reserved   
XMLROOTnon-reserved (cannot be function or type) reserved  
XMLSCHEMA non-reserved   
XMLSERIALIZEnon-reserved (cannot be function or type)reservedreserved  
XMLTABLE reserved   
XMLTEXT reserved   
XMLVALIDATE reserved   
YEARnon-reservedreservedreservedreservedreserved
YESnon-reservednon-reserved   
ZONEnon-reservednon-reservednon-reservedreservedreserved