Ключевые слова SQL

В таблице перечислены все токены, которые являются ключевыми словами в стандарте SQL и в QHB. Исходную информацию можно найти в Лексическая-структура (для исторического сравнения включены только две последние версии стандарта SQL и SQL-92. Различия между этими и другими промежуточными стандартными версиями невелики).

SQL различает зарезервированные и незарезервированные ключевые слова. Согласно стандарту, зарезервированные ключевые слова являются полноценными ключевыми словами; они никогда не допускаются в качестве идентификаторов. Незарезервированные ключевые слова имеют особое значение только в определенных контекстах и могут использоваться в качестве идентификаторов в других контекстах. Большинство незарезервированных ключевых слов на самом деле являются именами встроенных таблиц и функций, определенных SQL. Концепция незарезервированных ключевых слов, существует только для того, чтобы объявить, что в некоторых контекстах слову сопостовляется какое-то предопределенное значение.

В парсере QHB существует несколько различных классов токенов, начиная от тех, которые никогда не могут использоваться в качестве идентификатора, до тех, которые не имеют никакого специального статуса в анализаторе по сравнению с обычным идентификатором. (Последнее обычно имеет место для функций, определенных SQL). Даже зарезервированные ключевые слова но могут использоваться в качестве меток столбцов (например, SELECT 55 AS CHECK , даже если CHECK является зарезервированным ключевым словом).

В таблице в столбце для QHB как «non-reserved» определяются те ключевые слова, которые явно известны синтаксическому анализатору, но допускаются как имена столбцов или таблиц. Некоторые ключевые слова, которые в противном случае являются незарезервированными, не могут использоваться в качестве имен функций или типов данных и помечаются соответствующим образом. (Большинство этих слов представляют собой встроенные функции или типы данных со специальным синтаксисом. Функция или тип все еще доступны, но уже не могут быть переопределены пользователем). Пометкой «reserved» обозначаются те токены, которые не допускаются в качестве имен столбцов или таблиц. Некоторые зарезервированные ключевые слова допустимы в качестве имен для функций или типов данных; это также показано в таблице. Если не отмечено, зарезервированное ключевое слово допускается только в качестве имени метки столбца «AS».

Как правило, если вы получаете ложные ошибки синтаксического анализатора для команд, которые содержат любое из перечисленных ключевых слов в качестве идентификатора, вы должны попытаться заключить в кавычки идентификатор, чтобы увидеть, исчезнет ли проблема.

Перед изучением таблицы важно понять, что тот факт, что ключевое слово не зарезервировано в QHB, не означает, что функция, связанная со словом, не реализована. И наоборот, наличие ключевого слова не указывает на наличие функции.

Таблица Ключевые слова SQL

Ключевое словоQHB/PostreSQLSQL: 2016SQL: 2011SQL-92
Anon-reservednon-reserved
ABORTnon-reserved
ABSreservedreserved
ABSENTnon-reservednon-reserved
ABSOLUTEnon-reservednon-reservednon-reservedreserved
ACCESSnon-reserved
ACCORDINGnon-reservednon-reserved
ACOSreserved
ACTIONnon-reservednon-reservednon-reservedreserved
ADAnon-reservednon-reservednon-reserved
ADDnon-reservednon-reservednon-reservedreserved
ADMINnon-reservednon-reservednon-reserved
AFTERnon-reservednon-reservednon-reserved
AGGREGATEnon-reserved
ALLreservedreservedreservedreserved
ALLOCATEreservedreservedreserved
ALSOnon-reserved
ALTERnon-reservedreservedreservedreserved
ALWAYSnon-reservednon-reservednon-reserved
ANALYSEreserved
ANALYZEreserved
ANDreservedreservedreservedreserved
ANYreservedreservedreservedreserved
APPEND_ONLYreserved (может быть функцией или типом)non-reservednon-reservednon-reserved
AREreservedreservedreserved
ARRAYreservedreservedreserved
ARRAY_AGGreservedreserved
ARRAY_MAX_CARDINALITYreservedreserved
ASreservedreservedreservedreserved
ASCreservednon-reservednon-reservedreserved
ASENSITIVEreservedreserved
ASINreserved
ASSERTIONnon-reservednon-reservednon-reservedreserved
ASSIGNMENTnon-reservednon-reservednon-reserved
ASYMMETRICreservedreservedreserved
ATnon-reservedreservedreservedreserved
ATANreserved
ATOMICreservedreserved
ATTACHnon-reserved
ATTRIBUTEnon-reservednon-reservednon-reserved
ATTRIBUTESnon-reservednon-reserved
AUTHORIZATIONreserved (может быть функцией или типом)reservedreservedreserved
AVGreservedreservedreserved
BACKWARDnon-reserved
BASE64non-reservednon-reserved
BEFOREnon-reservednon-reservednon-reserved
BEGINnon-reservedreservedreservedreserved
BEGIN_FRAMEreservedreserved
BEGIN_PARTITIONreservedreserved
BERNOULLInon-reservednon-reserved
BETWEENnon-reserved (не может быть функцией или типом)reservedreservedreserved
BIGINTnon-reserved (не может быть функцией или типом)reservedreserved
BINARYreserved (может быть функцией или типом)reservedreserved
BITnon-reserved (не может быть функцией или типом)reserved
BIT_LENGTHreserved
BLOBreservedreserved
BLOCKEDnon-reservednon-reserved
BOMnon-reservednon-reserved
BOOLEANnon-reserved (не может быть функцией или типом)reservedreserved
BOTHreservedreservedreservedreserved
BREADTHnon-reservednon-reserved
BYnon-reservedreservedreservedreserved
Cnon-reservednon-reservednon-reserved
CACHEnon-reserved
CALLnon-reservedreservedreserved
CALLEDnon-reservedreservedreserved
CARDINALITYreservedreserved
CASCADEnon-reservednon-reservednon-reservedreserved
CASCADEDnon-reservedreservedreservedreserved
CASEreservedreservedreservedreserved
CASTreservedreservedreservedreserved
CATALOGnon-reservednon-reservednon-reservedreserved
CATALOG_NAMEnon-reservednon-reservednon-reserved
CEILreservedreserved
CEILINGreservedreserved
CHAINnon-reservednon-reservednon-reserved
CHAININGnon-reserved
CHARnon-reserved (не может быть функцией или типом)reservedreservedreserved
CHARACTERnon-reserved (не может быть функцией или типом)reservedreservedreserved
CHARACTERISTICSnon-reservednon-reservednon-reserved
CHARACTERSnon-reservednon-reserved
CHARACTER_LENGTHreservedreservedreserved
CHARACTER_SET_CATALOGnon-reservednon-reservednon-reserved
CHARACTER_SET_NAMEnon-reservednon-reservednon-reserved
CHARACTER_SET_SCHEMAnon-reservednon-reservednon-reserved
CHAR_LENGTHreservedreservedreserved
CHECKreservedreservedreservedreserved
CHECKPOINTnon-reserved
CLASSnon-reserved
CLASSIFIERreserved
CLASS_ORIGINnon-reservednon-reservednon-reserved
CLOBreservedreserved
CLOSEnon-reservedreservedreservedreserved
CLUSTERnon-reserved
COALESCEnon-reserved (не может быть функцией или типом)reservedreservedreserved
COBOLnon-reservednon-reservednon-reserved
COLLATEreservedreservedreservedreserved
COLLATIONreserved (может быть функцией или типом)non-reservednon-reservedreserved
COLLATION_CATALOGnon-reservednon-reservednon-reserved
COLLATION_NAMEnon-reservednon-reservednon-reserved
COLLATION_SCHEMAnon-reservednon-reservednon-reserved
COLLECTreservedreserved
COLUMNreservedreservedreservedreserved
COLUMNSnon-reservednon-reservednon-reserved
COLUMN_NAMEnon-reservednon-reservednon-reserved
COMMAND_FUNCTIONnon-reservednon-reservednon-reserved
COMMAND_FUNCTION_CODEnon-reservednon-reserved
COMMENTnon-reserved
COMMENTSnon-reserved
COMMITnon-reservedreservedreservedreserved
COMMITTEDnon-reservednon-reservednon-reservednon-reserved
CONCURRENTLYreserved (может быть функцией или типом)
CONDITIONreservedreserved
CONDITIONALnon-reserved
CONDITION_NUMBERnon-reservednon-reservednon-reserved
CONFIGURATIONnon-reserved
CONFLICTnon-reserved
CONNECTreservedreservedreserved
CONNECTIONnon-reservednon-reservednon-reservedreserved
CONNECTION_NAMEnon-reservednon-reservednon-reserved
CONSTRAINTreservedreservedreservedreserved
CONSTRAINTSnon-reservednon-reservednon-reservedreserved
CONSTRAINT_CATALOGnon-reservednon-reservednon-reserved
CONSTRAINT_NAMEnon-reservednon-reservednon-reserved
CONSTRAINT_SCHEMAnon-reservednon-reservednon-reserved
CONSTRUCTORnon-reservednon-reserved
CONTAINSreservedreserved
CONTENTnon-reservednon-reservednon-reserved
CONTINUEnon-reservednon-reservednon-reservedreserved
CONTROLnon-reservednon-reserved
CONVERSIONnon-reserved
CONVERTreservedreservedreserved
COPYnon-reservedreserved
CORRreservedreserved
CORRESPONDINGreservedreservedreserved
COSreserved
COSHreserved
COSTnon-reserved
COUNTreservedreservedreserved
COVAR_POPreservedreserved
COVAR_SAMPreservedreserved
CREATEreservedreservedreservedreserved
CROSSreserved (может быть функцией или типом)reservedreservedreserved
CSVnon-reserved
CUBEnon-reservedreservedreserved
CUME_DISTreservedreserved
CURRENTnon-reservedreservedreservedreserved
CURRENT_CATALOGreservedreservedreserved
CURRENT_DATEreservedreservedreservedreserved
CURRENT_DEFAULT_TRANSFORM_GROUPreservedreserved
CURRENT_PATHreservedreserved
CURRENT_ROLEreservedreservedreserved
CURRENT_ROWreservedreserved
CURRENT_SCHEMAreserved (может быть функцией или типом)reservedreserved
CURRENT_TIMEreservedreservedreservedreserved
CURRENT_TIMESTAMPreservedreservedreservedreserved
CURRENT_TRANSFORM_GROUP_FOR_TYPEreservedreserved
CURRENT_USERreservedreservedreservedreserved
CURSORnon-reservedreservedreservedreserved
CURSOR_NAMEnon-reservednon-reservednon-reserved
CYCLEnon-reservedreservedreserved
DATAnon-reservednon-reservednon-reservednon-reserved
DATABASEnon-reserved
DATALINKreservedreserved
DATEreservedreservedreserved
DATETIME_INTERVAL_CODEnon-reservednon-reservednon-reserved
DATETIME_INTERVAL_PRECISIONnon-reservednon-reservednon-reserved
DAYnon-reservedreservedreservedreserved
DBnon-reservednon-reserved
DEALLOCATEnon-reservedreservedreservedreserved
DECnon-reserved (не может быть функцией или типом)reservedreservedreserved
DECFLOATreserved
DECIMALnon-reserved (не может быть функцией или типом)reservedreservedreserved
DECLAREnon-reservedreservedreservedreserved
DEFAULTreservedreservedreservedreserved
DEFAULTSnon-reservednon-reservednon-reserved
DEFERRABLEreservednon-reservednon-reservedreserved
DEFERREDnon-reservednon-reservednon-reservedreserved
DEFINEreserved
DEFINEDnon-reservednon-reserved
DEFINERnon-reservednon-reservednon-reserved
DEGREEnon-reservednon-reserved
DELETEnon-reservedreservedreservedreserved
DELIMITERnon-reserved
DELIMITERSnon-reserved
DENSE_RANKreservedreserved
DEPENDSnon-reserved
DEPTHnon-reservednon-reserved
DEREFreservedreserved
DERIVEDnon-reservednon-reserved
DESCreservednon-reservednon-reservedreserved
DESCRIBEreservedreservedreserved
DESCRIPTORnon-reservednon-reservedreserved
DETACHnon-reserved
DETERMINISTICreservedreserved
DIAGNOSTICSnon-reservednon-reservedreserved
DICTIONARYnon-reserved
DISABLEnon-reserved
DISCARDnon-reserved
DISCONNECTreservedreservedreserved
DISPATCHnon-reservednon-reserved
DISTINCTreservedreservedreservedreserved
DLNEWCOPYreservedreserved
DLPREVIOUSCOPYreservedreserved
DLURLCOMPLETEreservedreserved
DLURLCOMPLETEONLYreservedreserved
DLURLCOMPLETEWRITEreservedreserved
DLURLPATHreservedreserved
DLURLPATHONLYreservedreserved
DLURLPATHWRITEreservedreserved
DLURLSCHEMEreservedreserved
DLURLSERVERreservedreserved
DLVALUEreservedreserved
DOreserved
DOCUMENTnon-reservednon-reservednon-reserved
DOMAINnon-reservednon-reservednon-reservedreserved
DOUBLEnon-reservedreservedreservedreserved
DROPnon-reservedreservedreservedreserved
DYNAMICreservedreserved
DYNAMIC_FUNCTIONnon-reservednon-reservednon-reserved
DYNAMIC_FUNCTION_CODEnon-reservednon-reserved
EACHnon-reservedreservedreserved
ELEMENTreservedreserved
ELSEreservedreservedreservedreserved
EMPTYreservednon-reserved
ENABLEnon-reserved
ENCODINGnon-reservednon-reservednon-reserved
ENCRYPTEDnon-reserved
ENDreservedreservedreservedreserved
END-EXECreservedreservedreserved
END_FRAMEreservedreserved
END_PARTITIONreservedreserved
ENFORCEDnon-reservednon-reserved
ENUMnon-reserved
EQUALSreservedreserved
ERRORnon-reserved
ESCAPEnon-reservedreservedreservedreserved
EVENTnon-reserved
EVERYreservedreserved
EXCEPTreservedreservedreservedreserved
EXCEPTIONreserved
EXCLUDEnon-reservednon-reservednon-reserved
EXCLUDINGnon-reservednon-reservednon-reserved
EXCLUSIVEnon-reserved
EXECreservedreservedreserved
EXECUTEnon-reservedreservedreservedreserved
EXISTSnon-reserved (не может быть функцией или типом)reservedreservedreserved
EXPreservedreserved
EXPLAINnon-reserved
EXPRESSIONnon-reservednon-reserved
EXTENSIONnon-reserved
EXTERNALnon-reservedreservedreservedreserved
EXTRACTnon-reserved (не может быть функцией или типом)reservedreservedreserved
FALSEreservedreservedreservedreserved
FAMILYnon-reserved
FETCHreservedreservedreservedreserved
FILEnon-reservednon-reserved
FILTERnon-reservedreservedreserved
FINALnon-reservednon-reserved
FINISHnon-reserved
FIRSTnon-reservednon-reservednon-reservedreserved
FIRST_VALUEreservedreserved
FLAGnon-reservednon-reserved
FLOATnon-reserved (не может быть функцией или типом)reservedreservedreserved
FLOORreservedreserved
FOLLOWINGnon-reservednon-reservednon-reserved
FORreservedreservedreservedreserved
FORCEnon-reserved
FOREIGNreservedreservedreservedreserved
FORMATnon-reserved
FORTRANnon-reservednon-reservednon-reserved
FORWARDnon-reserved
FOUNDnon-reservednon-reservedreserved
FRAME_ROWreservedreserved
FREEreservedreserved
FREEZEreserved (может быть функцией или типом)
FROMreservedreservedreservedreserved
FSnon-reservednon-reserved
FULFILLnon-reserved
FULLreserved (может быть функцией или типом)reservedreservedreserved
FUNCTIONnon-reservedreservedreserved
FUNCTIONSnon-reserved
FUSIONreservedreserved
Gnon-reservednon-reserved
GENERALnon-reservednon-reserved
GENERATEDnon-reservednon-reservednon-reserved
GETreservedreservedreserved
GLOBALnon-reservedreservedreservedreserved
GOnon-reservednon-reservedreserved
GOTOnon-reservednon-reservedreserved
GRANTreservedreservedreservedreserved
GRANTEDnon-reservednon-reservednon-reserved
GREATESTnon-reserved (не может быть функцией или типом)
GROUPreservedreservedreservedreserved
GROUPINGnon-reserved (не может быть функцией или типом)reservedreserved
GROUPSnon-reservedreservedreserved
HANDLERnon-reserved
HAVINGreservedreservedreservedreserved
HEADERnon-reserved
HEXnon-reservednon-reserved
HIERARCHYnon-reservednon-reserved
HOLDnon-reservedreservedreserved
HOURnon-reservedreservedreservedreserved
IDnon-reservednon-reserved
IDENTITYnon-reservedreservedreservedreserved
IFnon-reserved
IGNOREnon-reservednon-reserved
ILIKEreserved (может быть функцией или типом)
IMMEDIATEnon-reservednon-reservednon-reservedreserved
IMMEDIATELYnon-reservednon-reserved
IMMUTABLEnon-reserved
IMPLEMENTATIONnon-reservednon-reserved
IMPLICITnon-reserved
IMPORTnon-reservedreservedreserved
INreservedreservedreservedreserved
INCLUDEnon-reserved
INCLUDINGnon-reservednon-reservednon-reserved
INCREMENTnon-reservednon-reservednon-reserved
INDENTnon-reservednon-reserved
INDEXnon-reserved
INDEXESnon-reserved
INDICATORreservedreservedreserved
INHERITnon-reserved
INHERITSnon-reserved
INITIALreserved
INITIALLYreservednon-reservednon-reservedreserved
INLINEnon-reserved
INNERreserved (может быть функцией или типом)reservedreservedreserved
INOUTnon-reserved (не может быть функцией или типом)reservedreserved
INPUTnon-reservednon-reservednon-reservedreserved
INSENSITIVEnon-reservedreservedreservedreserved
INSERTnon-reservedreservedreservedreserved
INSTANCEnon-reservednon-reserved
INSTANTIABLEnon-reservednon-reserved
INSTEADnon-reservednon-reservednon-reserved
INTnon-reserved (не может быть функцией или типом)reservedreservedreserved
INTEGERnon-reserved (не может быть функцией или типом)reservedreservedreserved
INTEGRITYnon-reservednon-reserved
INTERSECTreservedreservedreservedreserved
INTERSECTIONreservedreserved
INTERVALnon-reserved (не может быть функцией или типом)reservedreservedreserved
INTOreservedreservedreservedreserved
INVOKERnon-reservednon-reservednon-reserved
ISreserved (может быть функцией или типом)reservedreservedreserved
ISNULLreserved (может быть функцией или типом)
ISOLATIONnon-reservednon-reservednon-reservedreserved
JOINreserved (может быть функцией или типом)reservedreservedreserved
JSONnon-reserved
JSON_ARRAYreserved
JSON_ARRAYAGGreserved
JSON_EXISTSreserved
JSON_OBJECTreserved
JSON_OBJECTAGGreserved
JSON_QUERYreserved
JSON_TABLEreserved
JSON_TABLE_PRIMITIVEreserved
JSON_VALUEreserved
Knon-reservednon-reserved
KEEPnon-reserved
KEYnon-reservednon-reservednon-reservedreserved
KEYSnon-reserved
KEY_MEMBERnon-reservednon-reserved
KEY_TYPEnon-reservednon-reserved
LABELnon-reserved
LAGreservedreserved
LANGUAGEnon-reservedreservedreservedreserved
LARGEnon-reservedreservedreserved
LASTnon-reservednon-reservednon-reservedreserved
LAST_VALUEreservedreserved
LATERALreservedreservedreserved
LEADreservedreserved
LEADINGreservedreservedreservedreserved
LEAKPROOFnon-reserved
LEASTnon-reserved (не может быть функцией или типом)
LEFTreserved (может быть функцией или типом)reservedreservedreserved
LENGTHnon-reservednon-reservednon-reserved
LEVELnon-reservednon-reservednon-reservedreserved
LIBRARYnon-reservednon-reserved
LIKEreserved (может быть функцией или типом)reservedreservedreserved
LIKE_REGEXreservedreserved
LIMITreservednon-reservednon-reserved
LINKnon-reservednon-reserved
LISTAGGreserved
LISTENnon-reserved
LNreservedreserved
LOADnon-reserved
LOCALnon-reservedreservedreservedreserved
LOCALTIMEreservedreservedreserved
LOCALTIMESTAMPreservedreservedreserved
LOCATIONnon-reservednon-reservednon-reserved
LOCATORnon-reservednon-reserved
LOCKnon-reserved
LOCKEDnon-reserved
LOGreserved
LOG10reserved
LOGGEDnon-reserved
LOWERreservedreservedreserved
Mnon-reservednon-reserved
MAPnon-reservednon-reserved
MAPPINGnon-reservednon-reservednon-reserved
MATCHnon-reservedreservedreservedreserved
MATCHEDnon-reservednon-reserved
MATCHESreserved
MATCH_NUMBERreserved
MATCH_RECOGNIZEreserved
MATERIALIZEDnon-reserved
MAXreservedreservedreserved
MAXVALUEnon-reservednon-reservednon-reserved
MEASURESreserved
MEMBERreservedreserved
MERGEreservedreserved
MESSAGE_LENGTHnon-reservednon-reservednon-reserved
MESSAGE_OCTET_LENGTHnon-reservednon-reservednon-reserved
MESSAGE_TEXTnon-reservednon-reservednon-reserved
METHODnon-reservedreservedreserved
MINreservedreservedreserved
MINUTEnon-reservedreservedreservedreserved
MINVALUEnon-reservednon-reservednon-reserved
MODreservedreserved
MODEnon-reserved
MODIFIESreservedreserved
MODULEreservedreservedreserved
MONTHnon-reservedreservedreservedreserved
MOREnon-reservednon-reservednon-reserved
MOVEnon-reserved
MULTISETreservedreserved
MUMPSnon-reservednon-reservednon-reserved
NAMEnon-reservednon-reservednon-reservednon-reserved
NAMESnon-reservednon-reservednon-reservedreserved
NAMESPACEnon-reservednon-reserved
NATIONALnon-reserved (не может быть функцией или типом)reservedreservedreserved
NATURALreserved (может быть функцией или типом)reservedreservedreserved
NCHARnon-reserved (не может быть функцией или типом)reservedreservedreserved
NCLOBreservedreserved
NESTEDnon-reserved
NESTINGnon-reservednon-reserved
NEWnon-reservedreservedreserved
NEXTnon-reservednon-reservednon-reservedreserved
NFCnon-reservednon-reserved
NFDnon-reservednon-reserved
NFKCnon-reservednon-reserved
NFKDnon-reservednon-reserved
NILnon-reservednon-reserved
NOnon-reservedreservedreservedreserved
NONEnon-reserved (не может быть функцией или типом)reservedreserved
NORMALIZEreservedreserved
NORMALIZEDnon-reservednon-reserved
NOTreservedreservedreservedreserved
NOTHINGnon-reserved
NOTIFYnon-reserved
NOTNULLreserved (может быть функцией или типом)
NOWAITnon-reserved
NTH_VALUEreservedreserved
NTILEreservedreserved
NULLreservedreservedreservedreserved
NULLABLEnon-reservednon-reservednon-reserved
NULLIFnon-reserved (не может быть функцией или типом)reservedreservedreserved
NULLSnon-reservednon-reservednon-reserved
NUMBERnon-reservednon-reservednon-reserved
NUMERICnon-reserved (не может быть функцией или типом)reservedreservedreserved
OBJECTnon-reservednon-reservednon-reserved
OCCURRENCES_REGEXreservedreserved
OCTETSnon-reservednon-reserved
OCTET_LENGTHreservedreservedreserved
OFnon-reservedreservedreservedreserved
OFFnon-reservednon-reservednon-reserved
OFFSETreservedreservedreserved
OIDSnon-reserved
OLDnon-reservedreservedreserved
OMITreserved
ONreservedreservedreservedreserved
ONEreserved
ONLYreservedreservedreservedreserved
OPENreservedreservedreserved
OPERATORnon-reserved
OPTIONnon-reservednon-reservednon-reservedreserved
OPTIONSnon-reservednon-reservednon-reserved
ORreservedreservedreservedreserved
ORDERreservedreservedreservedreserved
ORDERINGnon-reservednon-reserved
ORDINALITYnon-reservednon-reservednon-reserved
OTHERSnon-reservednon-reservednon-reserved
OUTnon-reserved (не может быть функцией или типом)reservedreserved
OUTERreserved (может быть функцией или типом)reservedreservedreserved
OUTPUTnon-reservednon-reservedreserved
OVERnon-reservedreservedreserved
OVERFLOWnon-reserved
OVERLAPSreserved (может быть функцией или типом)reservedreservedreserved
OVERLAYnon-reserved (не может быть функцией или типом)reservedreserved
OVERRIDINGnon-reservednon-reservednon-reserved
OWNEDnon-reserved
OWNERnon-reserved
Pnon-reservednon-reserved
PADnon-reservednon-reservedreserved
PARALLELnon-reserved
PARAMETERreservedreserved
PARAMETER_MODEnon-reservednon-reserved
PARAMETER_NAMEnon-reservednon-reserved
PARAMETER_ORDINAL_POSITIONnon-reservednon-reserved
PARAMETER_SPECIFIC_CATALOGnon-reservednon-reserved
PARAMETER_SPECIFIC_NAMEnon-reservednon-reserved
PARAMETER_SPECIFIC_SCHEMAnon-reservednon-reserved
PARSERnon-reserved
PARTIALnon-reservednon-reservednon-reservedreserved
PARTITIONnon-reservedreservedreserved
PASCALnon-reservednon-reservednon-reserved
PASSnon-reserved
PASSINGnon-reservednon-reservednon-reserved
PASSTHROUGHnon-reservednon-reserved
PASSWORDnon-reserved
PASTnon-reserved
PATHnon-reservednon-reserved
PATTERNreserved
PERreserved
PERCENTreservedreserved
PERCENTILE_CONTreservedreserved
PERCENTILE_DISCreservedreserved
PERCENT_RANKreservedreserved
PERIODreservedreserved
PERMISSIONnon-reservednon-reserved
PERMUTEreserved
PLACINGreservednon-reservednon-reserved
PLANnon-reserved
PLANSnon-reserved
PLInon-reservednon-reservednon-reserved
POLICYnon-reserved
PORTIONreservedreserved
POSITIONnon-reserved (не может быть функцией или типом)reservedreservedreserved
POSITION_REGEXreservedreserved
POWERreservedreserved
PRECEDESreservedreserved
PRECEDINGnon-reservednon-reservednon-reserved
PRECISIONnon-reserved (не может быть функцией или типом)reservedreservedreserved
PREPAREnon-reservedreservedreservedreserved
PREPAREDnon-reserved
PRESERVEnon-reservednon-reservednon-reservedreserved
PRIMARYreservedreservedreservedreserved
PRIORnon-reservednon-reservednon-reservedreserved
PRIVATEnon-reserved
PRIVILEGESnon-reservednon-reservednon-reservedreserved
PROCEDURALnon-reserved
PROCEDUREnon-reservedreservedreservedreserved
PROCEDURESnon-reserved
PROGRAMnon-reserved
PRUNEnon-reserved
PTFreserved
PUBLICnon-reservednon-reservedreserved
PUBLICATIONnon-reserved
QUOTEnon-reserved
QUOTESnon-reserved
RANGEnon-reservedreservedreserved
RANKreservedreserved
READnon-reservednon-reservednon-reservedreserved
READSreservedreserved
REALnon-reserved (не может быть функцией или типом)reservedreservedreserved
REASSIGNnon-reserved
RECHECKnon-reserved
RECOVERYnon-reservednon-reserved
RECURSIVEnon-reservedreservedreserved
REFnon-reservedreservedreserved
REFERENCESreservedreservedreservedreserved
REFERENCINGnon-reservedreservedreserved
REFRESHnon-reserved
REGR_AVGXreservedreserved
REGR_AVGYreservedreserved
REGR_COUNTreservedreserved
REGR_INTERCEPTreservedreserved
REGR_R2reservedreserved
REGR_SLOPEreservedreserved
REGR_SXXreservedreserved
REGR_SXYreservedreserved
REGR_SYYreservedreserved
REINDEXnon-reserved
RELATIVEnon-reservednon-reservednon-reservedreserved
RELEASEnon-reservedreservedreserved
RENAMEnon-reserved
REPEATABLEnon-reservednon-reservednon-reservednon-reserved
REPLACEnon-reserved
REPLICAnon-reserved
REQUIRINGnon-reservednon-reserved
RESETnon-reserved
RESPECTnon-reservednon-reserved
RESTARTnon-reservednon-reservednon-reserved
RESTOREnon-reservednon-reserved
RESTRICTnon-reservednon-reservednon-reservedreserved
RESULTreservedreserved
RETURNreservedreserved
RETURNED_CARDINALITYnon-reservednon-reserved
RETURNED_LENGTHnon-reservednon-reservednon-reserved
RETURNED_OCTET_LENGTHnon-reservednon-reservednon-reserved
RETURNED_SQLSTATEnon-reservednon-reservednon-reserved
RETURNINGreservednon-reservednon-reserved
RETURNSnon-reservedreservedreserved
REVOKEnon-reservedreservedreservedreserved
RIGHTreserved (может быть функцией или типом)reservedreservedreserved
ROLEnon-reservednon-reservednon-reserved
ROLLBACKnon-reservedreservedreservedreserved
ROLLUPnon-reservedreservedreserved
ROUTINEnon-reservednon-reservednon-reserved
ROUTINESnon-reserved
ROUTINE_CATALOGnon-reservednon-reserved
ROUTINE_NAMEnon-reservednon-reserved
ROUTINE_SCHEMAnon-reservednon-reserved
ROWnon-reserved (не может быть функцией или типом)reservedreserved
ROWSnon-reservedreservedreservedreserved
ROW_COUNTnon-reservednon-reservednon-reserved
ROW_NUMBERreservedreserved
RULEnon-reserved
RUNNINGreserved
SAVEPOINTnon-reservedreservedreserved
SCALARnon-reserved
SCALEnon-reservednon-reservednon-reserved
SCHEMAnon-reservednon-reservednon-reservedreserved
SCHEMASnon-reserved
SCHEMA_NAMEnon-reservednon-reservednon-reserved
SCOPEreservedreserved
SCOPE_CATALOGnon-reservednon-reserved
SCOPE_NAMEnon-reservednon-reserved
SCOPE_SCHEMAnon-reservednon-reserved
SCROLLnon-reservedreservedreservedreserved
SEARCHnon-reservedreservedreserved
SECONDnon-reservedreservedreservedreserved
SECTIONnon-reservednon-reservedreserved
SECURITYnon-reservednon-reservednon-reserved
SEEKreserved
SELECTreservedreservedreservedreserved
SELECTIVEnon-reservednon-reserved
SELFnon-reservednon-reserved
SENSITIVEreservedreserved
SEQUENCEnon-reservednon-reservednon-reserved
SEQUENCESnon-reserved
SERIALIZABLEnon-reservednon-reservednon-reservednon-reserved
SERVERnon-reservednon-reservednon-reserved
SERVER_NAMEnon-reservednon-reservednon-reserved
SESSIONnon-reservednon-reservednon-reservedreserved
SESSION_USERreservedreservedreservedreserved
SETnon-reservedreservedreservedreserved
SETOFnon-reserved (не может быть функцией или типом)
SETSnon-reservednon-reservednon-reserved
SHAREnon-reserved
SHOWnon-reservedreserved
SIMILARreserved (может быть функцией или типом)reservedreserved
SIMPLEnon-reservednon-reservednon-reserved
SINreserved
SINHreserved
SIZEnon-reservednon-reservedreserved
SKIPnon-reservedreserved
SMALLINTnon-reserved (не может быть функцией или типом)reservedreservedreserved
SNAPSHOTnon-reserved
SOMEreservedreservedreservedreserved
SOURCEnon-reservednon-reserved
SPACEnon-reservednon-reservedreserved
SPECIFICreservedreserved
SPECIFICTYPEreservedreserved
SPECIFIC_NAMEnon-reservednon-reserved
SQLnon-reservedreservedreservedreserved
SQLCODEreserved
SQLERRORreserved
SQLEXCEPTIONreservedreserved
SQLSTATEreservedreservedreserved
SQLWARNINGreservedreserved
SQRTreservedreserved
STABLEnon-reserved
STANDALONEnon-reservednon-reservednon-reserved
STARTnon-reservedreservedreserved
STATEnon-reservednon-reserved
STATEMENTnon-reservednon-reservednon-reserved
STATICreservedreserved
STATISTICSnon-reserved
STDDEV_POPreservedreserved
STDDEV_SAMPreservedreserved
STDINnon-reserved
STDOUTnon-reserved
STORAGEnon-reserved
STOREDnon-reserved
STRICTnon-reserved
STRINGnon-reserved
STRIPnon-reservednon-reservednon-reserved
STRUCTUREnon-reservednon-reserved
STYLEnon-reservednon-reserved
SUBCLASS_ORIGINnon-reservednon-reservednon-reserved
SUBMULTISETreservedreserved
SUBSCRIPTIONnon-reserved
SUBSETreserved
SUBSTRINGnon-reserved (не может быть функцией или типом)reservedreservedreserved
SUBSTRING_REGEXreservedreserved
SUCCEEDSreservedreserved
SUMreservedreservedreserved
SUPPORTnon-reserved
SYMMETRICreservedreservedreserved
SYSIDnon-reserved
SYSTEMnon-reservedreservedreserved
SYSTEM_TIMEreservedreserved
SYSTEM_USERreservedreservedreserved
Tnon-reservednon-reserved
TABLEreservedreservedreservedreserved
TABLESnon-reserved
TABLESAMPLEreserved (может быть функцией или типом)reservedreserved
TABLESPACEnon-reserved
TABLE_NAMEnon-reservednon-reservednon-reserved
TANreserved
TANHreserved
TEMPnon-reserved
TEMPLATEnon-reserved
TEMPORARYnon-reservednon-reservednon-reservedreserved
TEXTnon-reserved
THENreservedreservedreservedreserved
THROUGHnon-reserved
TIESnon-reservednon-reservednon-reserved
TIMEnon-reserved (не может быть функцией или типом)reservedreservedreserved
TIMESTAMPnon-reserved (не может быть функцией или типом)reservedreservedreserved
TIMEZONE_HOURreservedreservedreserved
TIMEZONE_MINUTEreservedreservedreserved
TOreservedreservedreservedreserved
TOKENnon-reservednon-reserved
TOP_LEVEL_COUNTnon-reservednon-reserved
TRAILINGreservedreservedreservedreserved
TRANSACTIONnon-reservednon-reservednon-reservedreserved
TRANSACTIONS_COMMITTEDnon-reservednon-reserved
TRANSACTIONS_ROLLED_BACKnon-reservednon-reserved
TRANSACTION_ACTIVEnon-reservednon-reserved
TRANSFORMnon-reservednon-reservednon-reserved
TRANSFORMSnon-reservednon-reserved
TRANSLATEreservedreservedreserved
TRANSLATE_REGEXreservedreserved
TRANSLATIONreservedreservedreserved
TREATnon-reserved (не может быть функцией или типом)reservedreserved
TRIGGERnon-reservedreservedreserved
TRIGGER_CATALOGnon-reservednon-reserved
TRIGGER_NAMEnon-reservednon-reserved
TRIGGER_SCHEMAnon-reservednon-reserved
TRIMnon-reserved (не может быть функцией или типом)reservedreservedreserved
TRIM_ARRAYreservedreserved
TRUEreservedreservedreservedreserved
TRUNCATEnon-reservedreservedreserved
TRUSTEDnon-reserved
TYPEnon-reservednon-reservednon-reservednon-reserved
TYPESnon-reserved
UESCAPEreservedreserved
UNBOUNDEDnon-reservednon-reservednon-reserved
UNCOMMITTEDnon-reservednon-reservednon-reservednon-reserved
UNCONDITIONALnon-reserved
UNDERnon-reservednon-reserved
UNENCRYPTEDnon-reserved
UNIONreservedreservedreservedreserved
UNIQUEreservedreservedreservedreserved
UNKNOWNnon-reservedreservedreservedreserved
UNLINKnon-reservednon-reserved
UNLISTENnon-reserved
UNLOGGEDnon-reserved
UNMATCHEDreserved
UNNAMEDnon-reservednon-reservednon-reserved
UNNESTreservedreserved
UNTILnon-reserved
UNTYPEDnon-reservednon-reserved
UPDATEnon-reservedreservedreservedreserved
UPPERreservedreservedreserved
URInon-reservednon-reserved
USAGEnon-reservednon-reservedreserved
USERreservedreservedreservedreserved
USER_DEFINED_TYPE_CATALOGnon-reservednon-reserved
USER_DEFINED_TYPE_CODEnon-reservednon-reserved
USER_DEFINED_TYPE_NAMEnon-reservednon-reserved
USER_DEFINED_TYPE_SCHEMAnon-reservednon-reserved
USINGreservedreservedreservedreserved
UTF16non-reserved
UTF32non-reserved
UTF8non-reserved
VACUUMnon-reserved
VALIDnon-reservednon-reservednon-reserved
VALIDATEnon-reserved
VALIDATORnon-reserved
VALUEnon-reservedreservedreservedreserved
VALUESnon-reserved (не может быть функцией или типом)reservedreservedreserved
VALUE_OFreservedreserved
VARBINARYreservedreserved
VARCHARnon-reserved (не может быть функцией или типом)reservedreservedreserved
VARIADICreserved
VARYINGnon-reservedreservedreservedreserved
VAR_POPreservedreserved
VAR_SAMPreservedreserved
VERBOSEreserved (может быть функцией или типом)
VERSIONnon-reservednon-reservednon-reserved
VERSIONINGreservedreserved
VIEWnon-reservednon-reservednon-reservedreserved
VIEWSnon-reserved
VOLATILEnon-reserved
WHENreservedreservedreservedreserved
WHENEVERreservedreservedreserved
WHEREreservedreservedreservedreserved
WHITESPACEnon-reservednon-reservednon-reserved
WIDTH_BUCKETreservedreserved
WINDOWreservedreservedreserved
WITHreservedreservedreservedreserved
WITHINnon-reservedreservedreserved
WITHOUTnon-reservedreservedreserved
WORKnon-reservednon-reservednon-reservedreserved
WRAPPERnon-reservednon-reservednon-reserved
WRITEnon-reservednon-reservednon-reservedreserved
XMLnon-reservedreservedreserved
XMLAGGreservedreserved
XMLATTRIBUTESnon-reserved (не может быть функцией или типом)reservedreserved
XMLBINARYreservedreserved
XMLCASTreservedreserved
XMLCOMMENTreservedreserved
XMLCONCATnon-reserved (не может быть функцией или типом)reservedreserved
XMLDECLARATIONnon-reservednon-reserved
XMLDOCUMENTreservedreserved
XMLELEMENTnon-reserved (не может быть функцией или типом)reservedreserved
XMLEXISTSnon-reserved (не может быть функцией или типом)reservedreserved
XMLFORESTnon-reserved (не может быть функцией или типом)reservedreserved
XMLITERATEreservedreserved
XMLNAMESPACESnon-reserved (не может быть функцией или типом)reservedreserved
XMLPARSEnon-reserved (не может быть функцией или типом)reservedreserved
XMLPInon-reserved (не может быть функцией или типом)reservedreserved
XMLQUERYreservedreserved
XMLROOTnon-reserved (не может быть функцией или типом)
XMLSCHEMAnon-reservednon-reserved
XMLSERIALIZEnon-reserved (не может быть функцией или типом)reservedreserved
XMLTABLEnon-reserved (не может быть функцией или типом)reservedreserved
XMLTEXTreservedreserved
XMLVALIDATEreservedreserved
YEARnon-reservedreservedreservedreserved
YESnon-reservednon-reservednon-reserved
ZONEnon-reservednon-reservednon-reservedreserved