9.3 9.4 9.5 9.6 10 11 12 13 14 15 Current(16) 17
问题报告 纠错本页面
附录 C. SQL关键词
上一页 上一级 部分 VIII. 附录起始页 下一页

附录 C. SQL关键词

表 C.1列出了在SQL标准以及PostgreSQL 15.7中作为关键词的所有记号。背景资料可以在第 4.1.1 节中找到(由于篇幅的缘故,只包括了SQL标准的最近两个版本以及用于与历史比较的SQL-92。这些版本以及其他中间标准的版本之间的差别很小)。

SQL区分保留关键词和非保留关键词。根据标准,保留关键词才是真正的关键词,它们绝不会被允许作为标识符。非关键词仅仅是在特定上下文中具有特殊的含义并且可以在其他上下文中被用作标识符。大部分非保留关键词实际上是SQL指定的内建表和内建函数的名字。非保留关键词的概念存在的意义上实际上是声明某些上下文中的一个词被附加了某种预定义的含义。

PostgreSQL的解析器中,情况更加复杂。其中有多种不同的记号分类,从那些决不能被用作标识符的记号到那些在解析器中绝对没有特殊状态,但被认为是普通的标识符。(后者通常是SQL中指定的函数)。在PostgreSQL中甚至保留关键词也不是完全被保留的,而是可以被用作列标签(例如可以写SELECT 55 AS CHECK,虽然CHECK是一个保留关键词)。

表 C.1PostgreSQL列中,我们把解析器明确知道但允许作为列名或者表名的那些关键词分类为"非保留"。有一些关键词是非保留的,但是不能被用作函数或数据类型名称,因此它们会被标记(大部分这些词表示有特殊语法的内建函数或数据类型。这种函数或类型仍然可用,但是不能被用户重新定义)。不允许作为列名或表名的记号被打上"保留"的标签。某些保留关键词被允许作为函数或数据类型的名字,这也显示在该表中。如果没有被那样标记,保留关键词仅被允许作为列标签。 这一列的空白项意味着这个词被PostgreSQL当作一个普通的标识符。

此外,虽然大多数关键词可以用作"bare"列标签,而不用在它们前面写AS(如第 7.3.2 节中描述的那样),但有一些需要在前面加上AS以避免歧义。 这些在表中被标记为"requires AS"

一般来说,如果你在使用任何所列出关键词作为标识符的命令,遇到虚假的解析器错误,应该尝试将该标识符加上引号来看看是否能解决问题。

在学习表 C.1之前有一件重要的事情是理解一个在PostgreSQL中不被保留的关键字并不意味着与该词相关的特性没有被实现。反过来,一个关键词的存在也不表示相应特性的存在。

表 C.1. SQL Key Words

Key WordPostgreSQLSQL:2016SQL:2011SQL-92
Anon-reservednon-reserved
ABORTnon-reserved
ABSreservedreserved
ABSENTreservednon-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
AREreservedreservedreserved
ARRAYreserved, requires ASreservedreserved
ARRAY_AGGreservedreserved
ARRAY_​MAX_​CARDINALITYreservedreserved
ASreserved, requires ASreservedreservedreserved
ASCreservednon-reservednon-reservedreserved
ASENSITIVEnon-reservedreservedreserved
ASINreserved
ASSERTIONnon-reservednon-reservednon-reservedreserved
ASSIGNMENTnon-reservednon-reservednon-reserved
ASYMMETRICreservedreservedreserved
ATnon-reservedreservedreservedreserved
ATANreserved
ATOMICnon-reservedreservedreserved
ATTACHnon-reserved
ATTRIBUTEnon-reservednon-reservednon-reserved
ATTRIBUTESnon-reservednon-reserved
AUTHORIZATIONreserved (can be function or type)reservedreservedreserved
AVGreservedreservedreserved
BACKWARDnon-reserved
BASE64non-reservednon-reserved
BEFOREnon-reservednon-reservednon-reserved
BEGINnon-reservedreservedreservedreserved
BEGIN_FRAMEreservedreserved
BEGIN_PARTITIONreservedreserved
BERNOULLInon-reservednon-reserved
BETWEENnon-reserved (cannot be function or type)reservedreservedreserved
BIGINTnon-reserved (cannot be function or type)reservedreserved
BINARYreserved (can be function or type)reservedreserved
BITnon-reserved (cannot be function or type)reserved
BIT_LENGTHreserved
BLOBreservedreserved
BLOCKEDnon-reservednon-reserved
BOMnon-reservednon-reserved
BOOLEANnon-reserved (cannot be function or type)reservedreserved
BOTHreservedreservedreservedreserved
BREADTHnon-reservednon-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 (cannot be function or type), requires ASreservedreservedreserved
CHARACTERnon-reserved (cannot be function or type), requires ASreservedreservedreserved
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 (cannot be function or type)reservedreservedreserved
COBOLnon-reservednon-reservednon-reserved
COLLATEreservedreservedreservedreserved
COLLATIONreserved (can be function or type)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
COMPRESSIONnon-reserved
CONCURRENTLYreserved (can be function or type)
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
CREATEreserved, requires ASreservedreservedreserved
CROSSreserved (can be function or type)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 (can be function or type)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-reserved, requires ASreservedreservedreserved
DBnon-reservednon-reserved
DEALLOCATEnon-reservedreservedreservedreserved
DECnon-reserved (cannot be function or type)reservedreservedreserved
DECFLOATreserved
DECIMALnon-reserved (cannot be function or type)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-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
EXCEPTreserved, requires ASreservedreservedreserved
EXCEPTIONreserved
EXCLUDEnon-reservednon-reservednon-reserved
EXCLUDINGnon-reservednon-reservednon-reserved
EXCLUSIVEnon-reserved
EXECreservedreservedreserved
EXECUTEnon-reservedreservedreservedreserved
EXISTSnon-reserved (cannot be function or type)reservedreservedreserved
EXPreservedreserved
EXPLAINnon-reserved
EXPRESSIONnon-reservednon-reservednon-reserved
EXTENSIONnon-reserved
EXTERNALnon-reservedreservedreservedreserved
EXTRACTnon-reserved (cannot be function or type)reservedreservedreserved
FALSEreservedreservedreservedreserved
FAMILYnon-reserved
FETCHreserved, requires ASreservedreservedreserved
FILEnon-reservednon-reserved
FILTERnon-reserved, requires ASreservedreserved
FINALnon-reservednon-reserved
FINALIZEnon-reserved
FINISHnon-reserved
FIRSTnon-reservednon-reservednon-reservedreserved
FIRST_VALUEreservedreserved
FLAGnon-reservednon-reserved
FLOATnon-reserved (cannot be function or type)reservedreservedreserved
FLOORreservedreserved
FOLLOWINGnon-reservednon-reservednon-reserved
FORreserved, requires ASreservedreservedreserved
FORCEnon-reserved
FOREIGNreservedreservedreservedreserved
FORMATnon-reserved
FORTRANnon-reservednon-reservednon-reserved
FORWARDnon-reserved
FOUNDnon-reservednon-reservedreserved
FRAME_ROWreservedreserved
FREEreservedreserved
FREEZEreserved (can be function or type)
FROMreserved, requires ASreservedreservedreserved
FSnon-reservednon-reserved
FULFILLnon-reserved
FULLreserved (can be function or type)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
GRANTreserved, requires ASreservedreservedreserved
GRANTEDnon-reservednon-reservednon-reserved
GREATESTnon-reserved (cannot be function or type)
GROUPreserved, requires ASreservedreservedreserved
GROUPINGnon-reserved (cannot be function or type)reservedreserved
GROUPSnon-reservedreservedreserved
HANDLERnon-reserved
HAVINGreserved, requires ASreservedreservedreserved
HEADERnon-reserved
HEXnon-reservednon-reserved
HIERARCHYnon-reservednon-reserved
HOLDnon-reservedreservedreserved
HOURnon-reserved, requires ASreservedreservedreserved
IDnon-reservednon-reserved
IDENTITYnon-reservedreservedreservedreserved
IFnon-reserved
IGNOREnon-reservednon-reserved
ILIKEreserved (can be function or type)
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 (can be function or type)reservedreservedreserved
INOUTnon-reserved (cannot be function or type)reservedreserved
INPUTnon-reservednon-reservednon-reservedreserved
INSENSITIVEnon-reservedreservedreservedreserved
INSERTnon-reservedreservedreservedreserved
INSTANCEnon-reservednon-reserved
INSTANTIABLEnon-reservednon-reserved
INSTEADnon-reservednon-reservednon-reserved
INTnon-reserved (cannot be function or type)reservedreservedreserved
INTEGERnon-reserved (cannot be function or type)reservedreservedreserved
INTEGRITYnon-reservednon-reserved
INTERSECTreserved, requires ASreservedreservedreserved
INTERSECTIONreservedreserved
INTERVALnon-reserved (cannot be function or type)reservedreservedreserved
INTOreserved, requires ASreservedreservedreserved
INVOKERnon-reservednon-reservednon-reserved
ISreserved (can be function or type)reservedreservedreserved
ISNULLreserved (can be function or type), requires AS
ISOLATIONnon-reservednon-reservednon-reservedreserved
JOINreserved (can be function or type)reservedreservedreserved
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 (cannot be function or type)
LEFTreserved (can be function or type)reservedreservedreserved
LENGTHnon-reservednon-reservednon-reserved
LEVELnon-reservednon-reservednon-reservedreserved
LIBRARYnon-reservednon-reserved
LIKEreserved (can be function or type)reservedreservedreserved
LIKE_REGEXreservedreserved
LIMITreserved, requires ASnon-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-reservednon-reserved
MATCHESreserved
MATCH_NUMBERreserved
MATCH_RECOGNIZEreserved
MATERIALIZEDnon-reserved
MAXreservedreservedreserved
MAXVALUEnon-reservednon-reservednon-reserved
MEASURESreserved
MEMBERreservedreserved
MERGEnon-reservedreservedreserved
MESSAGE_LENGTHnon-reservednon-reservednon-reserved
MESSAGE_OCTET_LENGTHnon-reservednon-reservednon-reserved
MESSAGE_TEXTnon-reservednon-reservednon-reserved
METHODnon-reservedreservedreserved
MINreservedreservedreserved
MINUTEnon-reserved, requires ASreservedreservedreserved
MINVALUEnon-reservednon-reservednon-reserved
MODreservedreserved
MODEnon-reserved
MODIFIESreservedreserved
MODULEreservedreservedreserved
MONTHnon-reserved, requires ASreservedreservedreserved
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 (cannot be function or type)reservedreservedreserved
NATURALreserved (can be function or type)reservedreservedreserved
NCHARnon-reserved (cannot be function or type)reservedreservedreserved
NCLOBreservedreserved
NESTEDnon-reserved
NESTINGnon-reservednon-reserved
NEWnon-reservedreservedreserved
NEXTnon-reservednon-reservednon-reservedreserved
NFCnon-reservednon-reservednon-reserved
NFDnon-reservednon-reservednon-reserved
NFKCnon-reservednon-reservednon-reserved
NFKDnon-reservednon-reservednon-reserved
NILnon-reservednon-reserved
NOnon-reservedreservedreservedreserved
NONEnon-reserved (cannot be function or type)reservedreserved
NORMALIZEnon-reserved (cannot be function or type)reservedreserved
NORMALIZEDnon-reservednon-reservednon-reserved
NOTreservedreservedreservedreserved
NOTHINGnon-reserved
NOTIFYnon-reserved
NOTNULLreserved (can be function or type), requires AS
NOWAITnon-reserved
NTH_VALUEreservedreserved
NTILEreservedreserved
NULLreservedreservedreservedreserved
NULLABLEnon-reservednon-reservednon-reserved
NULLIFnon-reserved (cannot be function or type)reservedreservedreserved
NULLSnon-reservednon-reservednon-reserved
NULL_ORDERINGnon-reserved
NUMBERnon-reservednon-reservednon-reserved
NUMERICnon-reserved (cannot be function or type)reservedreservedreserved
OBJECTnon-reservednon-reservednon-reserved
OCCURRENCEnon-reserved
OCCURRENCES_REGEXreservedreserved
OCTETSnon-reservednon-reserved
OCTET_LENGTHreservedreservedreserved
OFnon-reservedreservedreservedreserved
OFFnon-reservednon-reservednon-reserved
OFFSETreserved, requires ASreservedreserved
OIDSnon-reserved
OLDnon-reservedreservedreserved
OMITreserved
ONreserved, requires ASreservedreservedreserved
ONEreserved
ONLYreservedreservedreservedreserved
OPENreservedreservedreserved
OPERATORnon-reserved
OPTIONnon-reservednon-reservednon-reservedreserved
OPTIONSnon-reservednon-reservednon-reserved
ORreservedreservedreservedreserved
ORDERreserved, requires ASreservedreservedreserved
ORDERINGnon-reservednon-reserved
ORDINALITYnon-reservednon-reservednon-reserved
OTHERSnon-reservednon-reservednon-reserved
OUTnon-reserved (cannot be function or type)reservedreserved
OUTERreserved (can be function or type)reservedreservedreserved
OUTPUTnon-reservednon-reservedreserved
OVERnon-reserved, requires ASreservedreserved
OVERFLOWnon-reserved
OVERLAPSreserved (can be function or type), requires ASreservedreservedreserved
OVERLAYnon-reserved (cannot be function or type)reservedreserved
OVERRIDINGnon-reservednon-reservednon-reserved
OWNEDnon-reserved
OWNERnon-reserved
Pnon-reservednon-reserved
PADnon-reservednon-reservedreserved
PARALLELnon-reserved
PARAMETERnon-reservedreservedreserved
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
PIPEnon-reserved
PLACINGreservednon-reservednon-reserved
PLANnon-reserved
PLANSnon-reserved
PLInon-reservednon-reservednon-reserved
POLICYnon-reserved
PORTIONreservedreserved
POSITIONnon-reserved (cannot be function or type)reservedreservedreserved
POSITION_REGEXreservedreserved
POWERreservedreserved
PRECEDESreservedreserved
PRECEDINGnon-reservednon-reservednon-reserved
PRECISIONnon-reserved (cannot be function or type), requires ASreservedreservedreserved
PREPAREnon-reservedreservedreservedreserved
PREPAREDnon-reserved
PRESERVEnon-reservednon-reservednon-reservedreserved
PREVnon-reserved
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 (cannot be function or type)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
RETURNnon-reservedreservedreserved
RETURNED_CARDINALITYnon-reservednon-reserved
RETURNED_LENGTHnon-reservednon-reservednon-reserved
RETURNED_​OCTET_​LENGTHnon-reservednon-reservednon-reserved
RETURNED_SQLSTATEnon-reservednon-reservednon-reserved
RETURNINGreserved, requires ASnon-reservednon-reserved
RETURNSnon-reservedreservedreserved
REVOKEnon-reservedreservedreservedreserved
RIGHTreserved (can be function or type)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 (cannot be function or type)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-reserved, requires ASreservedreservedreserved
SECTIONnon-reservednon-reservedreserved
SECURITYnon-reservednon-reservednon-reserved
SEEKreserved
SELECTreservedreservedreservedreserved
SELECTIVEnon-reservednon-reserved
SELFnon-reservednon-reserved
SEMANTICSnon-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 (cannot be function or type)
SETSnon-reservednon-reservednon-reserved
SHAREnon-reserved
SHOWnon-reservedreserved
SIMILARreserved (can be function or type)reservedreserved
SIMPLEnon-reservednon-reservednon-reserved
SINreserved
SINHreserved
SIZEnon-reservednon-reservedreserved
SKIPnon-reservedreserved
SMALLINTnon-reserved (cannot be function or type)reservedreservedreserved
SNAPSHOTnon-reserved
SOMEreservedreservedreservedreserved
SORT_DIRECTIONnon-reserved
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 (cannot be function or type)reservedreservedreserved
SUBSTRING_REGEXreservedreserved
SUCCEEDSreservedreserved
SUMreservedreservedreserved
SUPPORTnon-reserved
SYMMETRICreservedreservedreserved
SYSIDnon-reserved
SYSTEMnon-reservedreservedreserved
SYSTEM_TIMEreservedreserved
SYSTEM_USERreservedreservedreserved
Tnon-reservednon-reserved
TABLEreservedreservedreservedreserved
TABLESnon-reserved
TABLESAMPLEreserved (can be function or type)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 (cannot be function or type)reservedreservedreserved
TIMESTAMPnon-reserved (cannot be function or type)reservedreservedreserved
TIMEZONE_HOURreservedreservedreserved
TIMEZONE_MINUTEreservedreservedreserved
TOreserved, requires ASreservedreservedreserved
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 (cannot be function or type)reservedreserved
TRIGGERnon-reservedreservedreserved
TRIGGER_CATALOGnon-reservednon-reserved
TRIGGER_NAMEnon-reservednon-reserved
TRIGGER_SCHEMAnon-reservednon-reserved
TRIMnon-reserved (cannot be function or type)reservedreservedreserved
TRIM_ARRAYreservedreserved
TRUEreservedreservedreservedreserved
TRUNCATEnon-reservedreservedreserved
TRUSTEDnon-reserved
TYPEnon-reservednon-reservednon-reservednon-reserved
TYPESnon-reserved
UESCAPEnon-reservedreservedreserved
UNBOUNDEDnon-reservednon-reservednon-reserved
UNCOMMITTEDnon-reservednon-reservednon-reservednon-reserved
UNCONDITIONALnon-reserved
UNDERnon-reservednon-reserved
UNENCRYPTEDnon-reserved
UNIONreserved, requires ASreservedreservedreserved
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 (cannot be function or type)reservedreservedreserved
VALUE_OFreservedreserved
VARBINARYreservedreserved
VARCHARnon-reserved (cannot be function or type)reservedreservedreserved
VARIADICreserved
VARYINGnon-reserved, requires ASreservedreservedreserved
VAR_POPreservedreserved
VAR_SAMPreservedreserved
VERBOSEreserved (can be function or type)
VERSIONnon-reservednon-reservednon-reserved
VERSIONINGreservedreserved
VIEWnon-reservednon-reservednon-reservedreserved
VIEWSnon-reserved
VOLATILEnon-reserved
WHENreservedreservedreservedreserved
WHENEVERreservedreservedreserved
WHEREreserved, requires ASreservedreservedreserved
WHITESPACEnon-reservednon-reservednon-reserved
WIDTH_BUCKETreservedreserved
WINDOWreserved, requires ASreservedreserved
WITHreserved, requires ASreservedreservedreserved
WITHINnon-reserved, requires ASreservedreserved
WITHOUTnon-reserved, requires ASreservedreserved
WORKnon-reservednon-reservednon-reservedreserved
WRAPPERnon-reservednon-reservednon-reserved
WRITEnon-reservednon-reservednon-reservedreserved
XMLnon-reservedreservedreserved
XMLAGGreservedreserved
XMLATTRIBUTESnon-reserved (cannot be function or type)reservedreserved
XMLBINARYreservedreserved
XMLCASTreservedreserved
XMLCOMMENTreservedreserved
XMLCONCATnon-reserved (cannot be function or type)reservedreserved
XMLDECLARATIONnon-reservednon-reserved
XMLDOCUMENTreservedreserved
XMLELEMENTnon-reserved (cannot be function or type)reservedreserved
XMLEXISTSnon-reserved (cannot be function or type)reservedreserved
XMLFORESTnon-reserved (cannot be function or type)reservedreserved
XMLITERATEreservedreserved
XMLNAMESPACESnon-reserved (cannot be function or type)reservedreserved
XMLPARSEnon-reserved (cannot be function or type)reservedreserved
XMLPInon-reserved (cannot be function or type)reservedreserved
XMLQUERYreservedreserved
XMLROOTnon-reserved (cannot be function or type)
XMLSCHEMAnon-reservednon-reserved
XMLSERIALIZEnon-reserved (cannot be function or type)reservedreserved
XMLTABLEnon-reserved (cannot be function or type)reservedreserved
XMLTEXTreservedreserved
XMLVALIDATEreservedreserved
YEARnon-reserved, requires ASreservedreservedreserved
YESnon-reservednon-reservednon-reserved
ZONEnon-reservednon-reservednon-reservedreserved


B.7. 儒略日期 起始页 附录 D. SQL 符合性

AltStyle によって変換されたページ (->オリジナル) /