Appendix C. SQL Key Words

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 8.3.7. 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:2003SQL:1999SQL-92
A non-reserved  
ABORTnon-reserved   
ABS reservednon-reserved 
ABSOLUTEnon-reservednon-reservedreservedreserved
ACCESSnon-reserved   
ACTIONnon-reservednon-reservedreservedreserved
ADA non-reservednon-reservednon-reserved
ADDnon-reservednon-reservedreservedreserved
ADMINnon-reservednon-reservedreserved 
AFTERnon-reservednon-reservedreserved 
AGGREGATEnon-reserved reserved 
ALIAS  reserved 
ALLreservedreservedreservedreserved
ALLOCATE reservedreservedreserved
ALSOnon-reserved   
ALTERnon-reservedreservedreservedreserved
ALWAYSnon-reservednon-reserved  
ANALYSEreserved   
ANALYZEreserved   
ANDreservedreservedreservedreserved
ANYreservedreservedreservedreserved
ARE reservedreservedreserved
ARRAYreservedreservedreserved 
ASreservedreservedreservedreserved
ASCreservednon-reservedreservedreserved
ASENSITIVE reservednon-reserved 
ASSERTIONnon-reservednon-reservedreservedreserved
ASSIGNMENTnon-reservednon-reservednon-reserved 
ASYMMETRICreservedreservednon-reserved 
ATnon-reservedreservedreservedreserved
ATOMIC reservednon-reserved 
ATTRIBUTE non-reserved  
ATTRIBUTES non-reserved  
AUTHORIZATIONreserved (can be function or type)reservedreservedreserved
AVG reservednon-reservedreserved
BACKWARDnon-reserved   
BASE64 non-reserved  
BEFOREnon-reservednon-reservedreserved 
BEGINnon-reservedreservedreservedreserved
BERNOULLI non-reserved  
BETWEENreserved (can be function or type)reservednon-reservedreserved
BIGINTnon-reserved (cannot be function or type)reserved  
BINARYreserved (can be function or type)reservedreserved 
BITnon-reserved (cannot be function or type) reservedreserved
BITVAR  non-reserved 
BIT_LENGTH  non-reservedreserved
BLOB reservedreserved 
BOOLEANnon-reserved (cannot be function or type)reservedreserved 
BOTHreservedreservedreservedreserved
BREADTH non-reservedreserved 
BYnon-reservedreservedreservedreserved
C non-reservednon-reservednon-reserved
CACHEnon-reserved   
CALL reservedreserved 
CALLEDnon-reservedreservednon-reserved 
CARDINALITY reservednon-reserved 
CASCADEnon-reservednon-reservedreservedreserved
CASCADEDnon-reservedreservedreservedreserved
CASEreservedreservedreservedreserved
CASTreservedreservedreservedreserved
CATALOG non-reservedreservedreserved
CATALOG_NAME non-reservednon-reservednon-reserved
CEIL reserved  
CEILING reserved  
CHAINnon-reservednon-reservednon-reserved 
CHARnon-reserved (cannot be function or type)reservedreservedreserved
CHARACTERnon-reserved (cannot be function or type)reservedreservedreserved
CHARACTERISTICSnon-reservednon-reserved  
CHARACTERS non-reserved  
CHARACTER_LENGTH reservednon-reservedreserved
CHARACTER_SET_CATALOG non-reservednon-reservednon-reserved
CHARACTER_SET_NAME non-reservednon-reservednon-reserved
CHARACTER_SET_SCHEMA non-reservednon-reservednon-reserved
CHAR_LENGTH reservednon-reservedreserved
CHECKreservedreservedreservedreserved
CHECKED  non-reserved 
CHECKPOINTnon-reserved   
CLASSnon-reserved reserved 
CLASS_ORIGIN non-reservednon-reservednon-reserved
CLOB reservedreserved 
CLOSEnon-reservedreservedreservedreserved
CLUSTERnon-reserved   
COALESCEnon-reserved (cannot be function or type)reservednon-reservedreserved
COBOL non-reservednon-reservednon-reserved
COLLATEreservedreservedreservedreserved
COLLATION non-reservedreservedreserved
COLLATION_CATALOG non-reservednon-reservednon-reserved
COLLATION_NAME non-reservednon-reservednon-reserved
COLLATION_SCHEMA non-reservednon-reservednon-reserved
COLLECT reserved  
COLUMNreservedreservedreservedreserved
COLUMN_NAME non-reservednon-reservednon-reserved
COMMAND_FUNCTION non-reservednon-reservednon-reserved
COMMAND_FUNCTION_CODE non-reservednon-reserved 
COMMENTnon-reserved   
COMMITnon-reservedreservedreservedreserved
COMMITTEDnon-reservednon-reservednon-reservednon-reserved
COMPLETION  reserved 
CONCURRENTLYnon-reserved   
CONDITION reserved  
CONDITION_NUMBER non-reservednon-reservednon-reserved
CONFIGURATIONnon-reserved   
CONNECT reservedreservedreserved
CONNECTIONnon-reservednon-reservedreservedreserved
CONNECTION_NAME non-reservednon-reservednon-reserved
CONSTRAINTreservedreservedreservedreserved
CONSTRAINTSnon-reservednon-reservedreservedreserved
CONSTRAINT_CATALOG non-reservednon-reservednon-reserved
CONSTRAINT_NAME non-reservednon-reservednon-reserved
CONSTRAINT_SCHEMA non-reservednon-reservednon-reserved
CONSTRUCTOR non-reservedreserved 
CONTAINS non-reservednon-reserved 
CONTENTnon-reservednon-reserved  
CONTINUE non-reservedreservedreserved
CONVERSIONnon-reserved   
CONVERT reservednon-reservedreserved
COPYnon-reserved   
CORR reserved  
CORRESPONDING reservedreservedreserved
COSTnon-reserved   
COUNT reservednon-reservedreserved
COVAR_POP reserved  
COVAR_SAMP reserved  
CREATEreservedreservedreservedreserved
CREATEDBnon-reserved   
CREATEROLEnon-reserved   
CREATEUSERnon-reserved   
CROSSreserved (can be function or type)reservedreservedreserved
CSVnon-reserved   
CUBE reservedreserved 
CUME_DIST reserved  
CURRENTnon-reservedreservedreservedreserved
CURRENT_DATEreservedreservedreservedreserved
CURRENT_DEFAULT_TRANSFORM_GROUP reserved  
CURRENT_PATH reservedreserved 
CURRENT_ROLEreservedreservedreserved 
CURRENT_TIMEreservedreservedreservedreserved
CURRENT_TIMESTAMPreservedreservedreservedreserved
CURRENT_TRANSFORM_GROUP_FOR_TYPE reserved  
CURRENT_USERreservedreservedreservedreserved
CURSORnon-reservedreservedreservedreserved
CURSOR_NAME non-reservednon-reservednon-reserved
CYCLEnon-reservedreservedreserved 
DATA non-reservedreservednon-reserved
DATABASEnon-reserved   
DATE reservedreservedreserved
DATETIME_INTERVAL_CODE non-reservednon-reservednon-reserved
DATETIME_INTERVAL_PRECISION non-reservednon-reservednon-reserved
DAYnon-reservedreservedreservedreserved
DEALLOCATEnon-reservedreservedreservedreserved
DECnon-reserved (cannot be function or type)reservedreservedreserved
DECIMALnon-reserved (cannot be function or type)reservedreservedreserved
DECLAREnon-reservedreservedreservedreserved
DEFAULTreservedreservedreservedreserved
DEFAULTSnon-reservednon-reserved  
DEFERRABLEreservednon-reservedreservedreserved
DEFERREDnon-reservednon-reservedreservedreserved
DEFINED non-reservednon-reserved 
DEFINERnon-reservednon-reservednon-reserved 
DEGREE non-reserved  
DELETEnon-reservedreservedreservedreserved
DELIMITERnon-reserved   
DELIMITERSnon-reserved   
DENSE_RANK reserved  
DEPTH non-reservedreserved 
DEREF reservedreserved 
DERIVED non-reserved  
DESCreservednon-reservedreservedreserved
DESCRIBE reservedreservedreserved
DESCRIPTOR non-reservedreservedreserved
DESTROY  reserved 
DESTRUCTOR  reserved 
DETERMINISTIC reservedreserved 
DIAGNOSTICS non-reservedreservedreserved
DICTIONARYnon-reserved reserved 
DISABLEnon-reserved   
DISCARDnon-reserved   
DISCONNECT reservedreservedreserved
DISPATCH non-reservednon-reserved 
DISTINCTreservedreservedreservedreserved
DOreserved   
DOCUMENTnon-reservednon-reserved  
DOMAINnon-reservednon-reservedreservedreserved
DOUBLEnon-reservedreservedreservedreserved
DROPnon-reservedreservedreservedreserved
DYNAMIC reservedreserved 
DYNAMIC_FUNCTION non-reservednon-reservednon-reserved
DYNAMIC_FUNCTION_CODE non-reservednon-reserved 
EACHnon-reservedreservedreserved 
ELEMENT reserved  
ELSEreservedreservedreservedreserved
ENABLEnon-reserved   
ENCODINGnon-reserved   
ENCRYPTEDnon-reserved   
ENDreservedreservedreservedreserved
END-EXEC reservedreservedreserved
ENUMnon-reserved   
EQUALS non-reservedreserved 
ESCAPEnon-reservedreservedreservedreserved
EVERY reservedreserved 
EXCEPTreservedreservedreservedreserved
EXCEPTION non-reservedreservedreserved
EXCLUDE non-reserved  
EXCLUDINGnon-reservednon-reserved  
EXCLUSIVEnon-reserved   
EXEC reservedreservedreserved
EXECUTEnon-reservedreservedreservedreserved
EXISTING  non-reserved 
EXISTSnon-reserved (cannot be function or type)reservednon-reservedreserved
EXP reserved  
EXPLAINnon-reserved   
EXTERNALnon-reservedreservedreservedreserved
EXTRACTnon-reserved (cannot be function or type)reservednon-reservedreserved
FALSEreservedreservedreservedreserved
FAMILYnon-reserved   
FETCHnon-reservedreservedreservedreserved
FILTER reserved  
FINAL non-reservednon-reserved 
FIRSTnon-reservednon-reservedreservedreserved
FLOATnon-reserved (cannot be function or type)reservedreservedreserved
FLOOR reserved  
FOLLOWING non-reserved  
FORreservedreservedreservedreserved
FORCEnon-reserved   
FOREIGNreservedreservedreservedreserved
FORTRAN non-reservednon-reservednon-reserved
FORWARDnon-reserved   
FOUND non-reservedreservedreserved
FREE reservedreserved 
FREEZEreserved (can be function or type)   
FROMreservedreservedreservedreserved
FULLreserved (can be function or type)reservedreservedreserved
FUNCTIONnon-reservedreservedreserved 
FUSION reserved  
G non-reservednon-reserved 
GENERAL non-reservedreserved 
GENERATED non-reservednon-reserved 
GET reservedreservedreserved
GLOBALnon-reservedreservedreservedreserved
GO non-reservedreservedreserved
GOTO non-reservedreservedreserved
GRANTreservedreservedreservedreserved
GRANTEDnon-reservednon-reservednon-reserved 
GREATESTnon-reserved (cannot be function or type)   
GROUPreservedreservedreservedreserved
GROUPING reservedreserved 
HANDLERnon-reserved   
HAVINGreservedreservedreservedreserved
HEADERnon-reserved   
HEX non-reserved  
HIERARCHY non-reservednon-reserved 
HOLDnon-reservedreservednon-reserved 
HOST  reserved 
HOURnon-reservedreservedreservedreserved
IDENTITY reservedreservedreserved
IFnon-reserved   
IGNORE  reserved 
ILIKEreserved (can be function or type)   
IMMEDIATEnon-reservednon-reservedreservedreserved
IMMUTABLEnon-reserved   
IMPLEMENTATION non-reservednon-reserved 
IMPLICITnon-reserved   
INreservedreservedreservedreserved
INCLUDINGnon-reservednon-reserved  
INCREMENTnon-reservednon-reserved  
INDEXnon-reserved   
INDEXESnon-reserved   
INDICATOR reservedreservedreserved
INFIX  non-reserved 
INHERITnon-reserved   
INHERITSnon-reserved   
INITIALIZE  reserved 
INITIALLYreservednon-reservedreservedreserved
INNERreserved (can be function or type)reservedreservedreserved
INOUTnon-reserved (cannot be function or type)reservedreserved 
INPUTnon-reservednon-reservedreservedreserved
INSENSITIVEnon-reservedreservednon-reservedreserved
INSERTnon-reservedreservedreservedreserved
INSTANCE non-reservednon-reserved 
INSTANTIABLE non-reservednon-reserved 
INSTEADnon-reserved   
INTnon-reserved (cannot be function or type)reservedreservedreserved
INTEGERnon-reserved (cannot be function or type)reservedreservedreserved
INTERSECTreservedreservedreservedreserved
INTERSECTION reserved  
INTERVALnon-reserved (cannot be function or type)reservedreservedreserved
INTOreservedreservedreservedreserved
INVOKERnon-reservednon-reservednon-reserved 
ISreserved (can be function or type)reservedreservedreserved
ISNULLreserved (can be function or type)   
ISOLATIONnon-reservednon-reservedreservedreserved
ITERATE  reserved 
JOINreserved (can be function or type)reservedreservedreserved
K non-reservednon-reserved 
KEYnon-reservednon-reservedreservedreserved
KEY_MEMBER non-reservednon-reserved 
KEY_TYPE non-reservednon-reserved 
LANCOMPILERnon-reserved   
LANGUAGEnon-reservedreservedreservedreserved
LARGEnon-reservedreservedreserved 
LASTnon-reservednon-reservedreservedreserved
LATERAL reservedreserved 
LEADINGreservedreservedreservedreserved
LEASTnon-reserved (cannot be function or type)   
LEFTreserved (can be function or type)reservedreservedreserved
LENGTH non-reservednon-reservednon-reserved
LESS  reserved 
LEVELnon-reservednon-reservedreservedreserved
LIKEreserved (can be function or type)reservedreservedreserved
LIMITreserved reserved 
LISTENnon-reserved   
LN reserved  
LOADnon-reserved   
LOCALnon-reservedreservedreservedreserved
LOCALTIMEreservedreservedreserved 
LOCALTIMESTAMPreservedreservedreserved 
LOCATIONnon-reserved   
LOCATOR non-reservedreserved 
LOCKnon-reserved   
LOGINnon-reserved   
LOWER reservednon-reservedreserved
M non-reservednon-reserved 
MAP non-reservedreserved 
MAPPINGnon-reserved   
MATCHnon-reservedreservedreservedreserved
MATCHED non-reserved  
MAX reservednon-reservedreserved
MAXVALUEnon-reservednon-reserved  
MEMBER reserved  
MERGE reserved  
MESSAGE_LENGTH non-reservednon-reservednon-reserved
MESSAGE_OCTET_LENGTH non-reservednon-reservednon-reserved
MESSAGE_TEXT non-reservednon-reservednon-reserved
METHOD reservednon-reserved 
MIN reservednon-reservedreserved
MINUTEnon-reservedreservedreservedreserved
MINVALUEnon-reservednon-reserved  
MOD reservednon-reserved 
MODEnon-reserved   
MODIFIES reservedreserved 
MODIFY  reserved 
MODULE reservedreservedreserved
MONTHnon-reservedreservedreservedreserved
MORE non-reservednon-reservednon-reserved
MOVEnon-reserved   
MULTISET reserved  
MUMPS non-reservednon-reservednon-reserved
NAMEnon-reservednon-reservednon-reservednon-reserved
NAMESnon-reservednon-reservedreservedreserved
NATIONALnon-reserved (cannot be function or type)reservedreservedreserved
NATURALreserved (can be function or type)reservedreservedreserved
NCHARnon-reserved (cannot be function or type)reservedreservedreserved
NCLOB reservedreserved 
NESTING non-reserved  
NEWreservedreservedreserved 
NEXTnon-reservednon-reservedreservedreserved
NOnon-reservedreservedreservedreserved
NOCREATEDBnon-reserved   
NOCREATEROLEnon-reserved   
NOCREATEUSERnon-reserved   
NOINHERITnon-reserved   
NOLOGINnon-reserved   
NONEnon-reserved (cannot be function or type)reservedreserved 
NORMALIZE reserved  
NORMALIZED non-reserved  
NOSUPERUSERnon-reserved   
NOTreservedreservedreservedreserved
NOTHINGnon-reserved   
NOTIFYnon-reserved   
NOTNULLreserved (can be function or type)   
NOWAITnon-reserved   
NULLreservedreservedreservedreserved
NULLABLE non-reservednon-reservednon-reserved
NULLIFnon-reserved (cannot be function or type)reservednon-reservedreserved
NULLSnon-reservednon-reserved  
NUMBER non-reservednon-reservednon-reserved
NUMERICnon-reserved (cannot be function or type)reservedreservedreserved
OBJECTnon-reservednon-reservedreserved 
OCTETS non-reserved  
OCTET_LENGTH reservednon-reservedreserved
OFnon-reservedreservedreservedreserved
OFFreserved reserved 
OFFSETreserved   
OIDSnon-reserved   
OLDreservedreservedreserved 
ONreservedreservedreservedreserved
ONLYreservedreservedreservedreserved
OPEN reservedreservedreserved
OPERATION  reserved 
OPERATORnon-reserved   
OPTIONnon-reservednon-reservedreservedreserved
OPTIONS non-reservednon-reserved 
ORreservedreservedreservedreserved
ORDERreservedreservedreservedreserved
ORDERING non-reserved  
ORDINALITY non-reservedreserved 
OTHERS non-reserved  
OUTnon-reserved (cannot be function or type)reservedreserved 
OUTERreserved (can be function or type)reservedreservedreserved
OUTPUT non-reservedreservedreserved
OVER reserved  
OVERLAPSreserved (can be function or type)reservednon-reservedreserved
OVERLAYnon-reserved (cannot be function or type)reservednon-reserved 
OVERRIDING non-reservednon-reserved 
OWNEDnon-reserved   
OWNERnon-reserved   
PAD non-reservedreservedreserved
PARAMETER reservedreserved 
PARAMETERS  reserved 
PARAMETER_MODE non-reservednon-reserved 
PARAMETER_NAME non-reservednon-reserved 
PARAMETER_ORDINAL_POSITION non-reservednon-reserved 
PARAMETER_SPECIFIC_CATALOG non-reservednon-reserved 
PARAMETER_SPECIFIC_NAME non-reservednon-reserved 
PARAMETER_SPECIFIC_SCHEMA non-reservednon-reserved 
PARSERnon-reserved   
PARTIALnon-reservednon-reservedreservedreserved
PARTITION reserved  
PASCAL non-reservednon-reservednon-reserved
PASSWORDnon-reserved   
PATH non-reservedreserved 
PERCENTILE_CONT reserved  
PERCENTILE_DISC reserved  
PERCENT_RANK reserved  
PLACINGreservednon-reserved  
PLANSnon-reserved   
PLI non-reservednon-reservednon-reserved
POSITIONnon-reserved (cannot be function or type)reservednon-reservedreserved
POSTFIX  reserved 
POWER reserved  
PRECEDING non-reserved  
PRECISIONnon-reserved (cannot be function or type)reservedreservedreserved
PREFIX  reserved 
PREORDER  reserved 
PREPAREnon-reservedreservedreservedreserved
PREPAREDnon-reserved   
PRESERVEnon-reservednon-reservedreservedreserved
PRIMARYreservedreservedreservedreserved
PRIORnon-reservednon-reservedreservedreserved
PRIVILEGESnon-reservednon-reservedreservedreserved
PROCEDURALnon-reserved   
PROCEDUREnon-reservedreservedreservedreserved
PUBLIC non-reservedreservedreserved
QUOTEnon-reserved   
RANGE reserved  
RANK reserved  
READnon-reservednon-reservedreservedreserved
READS reservedreserved 
REALnon-reserved (cannot be function or type)reservedreservedreserved
REASSIGNnon-reserved   
RECHECKnon-reserved   
RECURSIVE reservedreserved 
REF reservedreserved 
REFERENCESreservedreservedreservedreserved
REFERENCING reservedreserved 
REGR_AVGX reserved  
REGR_AVGY reserved  
REGR_COUNT reserved  
REGR_INTERCEPT reserved  
REGR_R2 reserved  
REGR_SLOPE reserved  
REGR_SXX reserved  
REGR_SXY reserved  
REGR_SYY reserved  
REINDEXnon-reserved   
RELATIVEnon-reservednon-reservedreservedreserved
RELEASEnon-reservedreserved  
RENAMEnon-reserved   
REPEATABLEnon-reservednon-reservednon-reservednon-reserved
REPLACEnon-reserved   
REPLICAnon-reserved   
RESETnon-reserved   
RESTARTnon-reservednon-reserved  
RESTRICTnon-reservednon-reservedreservedreserved
RESULT reservedreserved 
RETURN reservedreserved 
RETURNED_CARDINALITY non-reserved  
RETURNED_LENGTH non-reservednon-reservednon-reserved
RETURNED_OCTET_LENGTH non-reservednon-reservednon-reserved
RETURNED_SQLSTATE non-reservednon-reservednon-reserved
RETURNINGreserved   
RETURNSnon-reservedreservedreserved 
REVOKEnon-reservedreservedreservedreserved
RIGHTreserved (can be function or type)reservedreservedreserved
ROLEnon-reservednon-reservedreserved 
ROLLBACKnon-reservedreservedreservedreserved
ROLLUP reservedreserved 
ROUTINE non-reservedreserved 
ROUTINE_CATALOG non-reservednon-reserved 
ROUTINE_NAME non-reservednon-reserved 
ROUTINE_SCHEMA non-reservednon-reserved 
ROWnon-reserved (cannot be function or type)reservedreserved 
ROWSnon-reservedreservedreservedreserved
ROW_COUNT non-reservednon-reservednon-reserved
ROW_NUMBER reserved  
RULEnon-reserved   
SAVEPOINTnon-reservedreservedreserved 
SCALE non-reservednon-reservednon-reserved
SCHEMAnon-reservednon-reservedreservedreserved
SCHEMA_NAME non-reservednon-reservednon-reserved
SCOPE reservedreserved 
SCOPE_CATALOG non-reserved  
SCOPE_NAME non-reserved  
SCOPE_SCHEMA non-reserved  
SCROLLnon-reservedreservedreservedreserved
SEARCHnon-reservedreservedreserved 
SECONDnon-reservedreservedreservedreserved
SECTION non-reservedreservedreserved
SECURITYnon-reservednon-reservednon-reserved 
SELECTreservedreservedreservedreserved
SELF non-reservednon-reserved 
SENSITIVE reservednon-reserved 
SEQUENCEnon-reservednon-reservedreserved 
SERIALIZABLEnon-reservednon-reservednon-reservednon-reserved
SERVER_NAME non-reservednon-reservednon-reserved
SESSIONnon-reservednon-reservedreservedreserved
SESSION_USERreservedreservedreservedreserved
SETnon-reservedreservedreservedreserved
SETOFnon-reserved (cannot be function or type)   
SETS non-reservedreserved 
SHAREnon-reserved   
SHOWnon-reserved   
SIMILARreserved (can be function or type)reservednon-reserved 
SIMPLEnon-reservednon-reservednon-reserved 
SIZE non-reservedreservedreserved
SMALLINTnon-reserved (cannot be function or type)reservedreservedreserved
SOMEreservedreservedreservedreserved
SOURCE non-reservednon-reserved 
SPACE non-reservedreservedreserved
SPECIFIC reservedreserved 
SPECIFICTYPE reservedreserved 
SPECIFIC_NAME non-reservednon-reserved 
SQL reservedreservedreserved
SQLCODE   reserved
SQLERROR   reserved
SQLEXCEPTION reservedreserved 
SQLSTATE reservedreservedreserved
SQLWARNING reservedreserved 
SQRT reserved  
STABLEnon-reserved   
STANDALONEnon-reservednon-reserved  
STARTnon-reservedreservedreserved 
STATE non-reservedreserved 
STATEMENTnon-reservednon-reservedreserved 
STATIC reservedreserved 
STATISTICSnon-reserved   
STDDEV_POP reserved  
STDDEV_SAMP reserved  
STDINnon-reserved   
STDOUTnon-reserved   
STORAGEnon-reserved   
STRICTnon-reserved   
STRIPnon-reservednon-reserved  
STRUCTURE non-reservedreserved 
STYLE non-reservednon-reserved 
SUBCLASS_ORIGIN non-reservednon-reservednon-reserved
SUBLIST  non-reserved 
SUBMULTISET reserved  
SUBSTRINGnon-reserved (cannot be function or type)reservednon-reservedreserved
SUM reservednon-reservedreserved
SUPERUSERnon-reserved   
SYMMETRICreservedreservednon-reserved 
SYSIDnon-reserved   
SYSTEMnon-reservedreservednon-reserved 
SYSTEM_USER reservedreservedreserved
TABLEreservedreservedreservedreserved
TABLESAMPLE reserved  
TABLESPACEnon-reserved   
TABLE_NAME non-reservednon-reservednon-reserved
TEMPnon-reserved   
TEMPLATEnon-reserved   
TEMPORARYnon-reservednon-reservedreservedreserved
TERMINATE  reserved 
TEXTnon-reserved   
THAN  reserved 
THENreservedreservedreservedreserved
TIES non-reserved  
TIMEnon-reserved (cannot be function or type)reservedreservedreserved
TIMESTAMPnon-reserved (cannot be function or type)reservedreservedreserved
TIMEZONE_HOUR reservedreservedreserved
TIMEZONE_MINUTE reservedreservedreserved
TOreservedreservedreservedreserved
TOP_LEVEL_COUNT non-reserved  
TRAILINGreservedreservedreservedreserved
TRANSACTIONnon-reservednon-reservedreservedreserved
TRANSACTIONS_COMMITTED non-reservednon-reserved 
TRANSACTIONS_ROLLED_BACK non-reservednon-reserved 
TRANSACTION_ACTIVE non-reservednon-reserved 
TRANSFORM non-reservednon-reserved 
TRANSFORMS non-reservednon-reserved 
TRANSLATE reservednon-reservedreserved
TRANSLATION reservedreservedreserved
TREATnon-reserved (cannot be function or type)reservedreserved 
TRIGGERnon-reservedreservedreserved 
TRIGGER_CATALOG non-reservednon-reserved 
TRIGGER_NAME non-reservednon-reserved 
TRIGGER_SCHEMA non-reservednon-reserved 
TRIMnon-reserved (cannot be function or type)reservednon-reservedreserved
TRUEreservedreservedreservedreserved
TRUNCATEnon-reserved   
TRUSTEDnon-reserved   
TYPEnon-reservednon-reservednon-reservednon-reserved
UESCAPE reserved  
UNBOUNDED non-reserved  
UNCOMMITTEDnon-reservednon-reservednon-reservednon-reserved
UNDER non-reservedreserved 
UNENCRYPTEDnon-reserved   
UNIONreservedreservedreservedreserved
UNIQUEreservedreservedreservedreserved
UNKNOWNnon-reservedreservedreservedreserved
UNLISTENnon-reserved   
UNNAMED non-reservednon-reservednon-reserved
UNNEST reservedreserved 
UNTILnon-reserved   
UPDATEnon-reservedreservedreservedreserved
UPPER reservednon-reservedreserved
USAGE non-reservedreservedreserved
USERreservedreservedreservedreserved
USER_DEFINED_TYPE_CATALOG non-reservednon-reserved 
USER_DEFINED_TYPE_CODE non-reserved  
USER_DEFINED_TYPE_NAME non-reservednon-reserved 
USER_DEFINED_TYPE_SCHEMA non-reservednon-reserved 
USINGreservedreservedreservedreserved
VACUUMnon-reserved   
VALIDnon-reserved   
VALIDATORnon-reserved   
VALUEnon-reservedreservedreservedreserved
VALUESnon-reserved (cannot be function or type)reservedreservedreserved
VARCHARnon-reserved (cannot be function or type)reservedreservedreserved
VARIABLE  reserved 
VARYINGnon-reservedreservedreservedreserved
VAR_POP reserved  
VAR_SAMP reserved  
VERBOSEreserved (can be function or type)   
VERSIONnon-reservednon-reserved  
VIEWnon-reservednon-reservedreservedreserved
VOLATILEnon-reserved   
WHENreservedreservedreservedreserved
WHENEVER reservedreservedreserved
WHEREreservedreservedreservedreserved
WHITESPACEnon-reservednon-reserved  
WIDTH_BUCKET reserved  
WINDOW reserved  
WITHreservedreservedreservedreserved
WITHIN reserved  
WITHOUTnon-reservedreservedreserved 
WORKnon-reservednon-reservedreservedreserved
WRITEnon-reservednon-reservedreservedreserved
XMLnon-reservedreserved  
XMLAGG reserved  
XMLATTRIBUTESnon-reserved (cannot be function or type)reserved  
XMLBINARY reserved  
XMLCOMMENT reserved  
XMLCONCATnon-reserved (cannot be function or type)reserved  
XMLELEMENTnon-reserved (cannot be function or type)reserved  
XMLFORESTnon-reserved (cannot be function or type)reserved  
XMLNAMESPACES reserved  
XMLPARSEnon-reserved (cannot be function or type)reserved  
XMLPInon-reserved (cannot be function or type)reserved  
XMLROOTnon-reserved (cannot be function or type)reserved  
XMLSERIALIZEnon-reserved (cannot be function or type)reserved  
YEARnon-reservedreservedreservedreserved
YESnon-reserved   
ZONEnon-reservednon-reservedreservedreserved