附录 C.SQL 关键字

Table C.1列出了 SQL 标准和 PostgreSQL 11.8 中所有作为关键字的标记。背景信息可以在Section 4.1.1中找到。 (由于篇幅原因,仅包括最新的两个 SQL 标准版本以及用于历史比较的 SQL-92.这些版本与其他中间标准版本之间的差异很小.)

SQL 区分保留非保留关键字。根据标准,保留关键字是唯一的真实关键字;保留关键字是唯一的关键字。绝对不允许将它们用作标识符。非保留关键字仅在特定上下文中具有特殊含义,并且可以在其他上下文中用作标识符。实际上,大多数非保留关键字都是 SQL 指定的内置表和函数的名称。非保留关键字的概念实质上仅是为了声明某些上下文中的单词附加了一些 sched 义的含义而存在。

在 PostgreSQL 解析器中,生活有些复杂。令牌有几种不同的类别,从永远不能用作标识符的令牌到与普通标识符相比在解析器中绝对没有特殊状态的令牌。 (对于 SQL 指定的函数,通常是后者.)即使保留的关键字在 PostgreSQL 中也不是完全保留的,但是可以用作列标签(例如SELECT 55 AS CHECK,即使CHECK是保留的关键字)。

在 PostgreSQL 列的Table C.1中,我们将解析器明确知道但允许用作列名或表名的那些关键字分类为“非保留”。某些原本不可保留的关键字不能用作功能或数据类型名称,并进行了相应标记。 (这些词中的大多数代表具有特殊语法的内置函数或数据类型.该函数或类型仍然可用,但用户无法重新定义.)标记为“保留”的是那些不允许用作列或表名的标记。某些保留的关键字可以用作函数或数据类型的名称。这也显示在表格中。如果没有这样标记,则保留的关键字仅允许用作“ AS”列标签名称。

通常,如果对于包含任何列出的关键字作为标识符的命令,收到虚 Pseudo 解析器错误,则应尝试引用该标识符以查看问题是否消失。

在研究Table C.1之前,必须了解,在 PostgreSQL 中未保留关键字这一事实并不意味着未实现与该关键字相关的功能,这一点很重要。相反,关键字的存在并不表示 Feature 的存在。

表 C.1.SQL 关键字

Key WordPostgreSQLSQL:2011SQL:2008SQL-92
A non-reservednon-reserved
ABORTnon-reserved
ABS reservedreserved
ABSENT non-reservednon-reserved
ABSOLUTEnon-reservednon-reservednon-reservedreserved
ACCESSnon-reserved
ACCORDING non-reservednon-reserved
ACTIONnon-reservednon-reservednon-reservedreserved
ADA non-reservednon-reservednon-reserved
ADDnon-reservednon-reservednon-reservedreserved
ADMINnon-reservednon-reservednon-reserved
AFTERnon-reservednon-reservednon-reserved
AGGREGATEnon-reserved
ALLreservedreservedreservedreserved
ALLOCATE reservedreservedreserved
ALSOnon-reserved
ALTERnon-reservedreservedreservedreserved
ALWAYSnon-reservednon-reservednon-reserved
ANALYSEreserved
ANALYZEreserved
ANDreservedreservedreservedreserved
ANYreservedreservedreservedreserved
ARE reservedreservedreserved
ARRAYreservedreservedreserved
ARRAY_AGG reservedreserved
ARRAY_MAX_CARDINALITY reserved
ASreservedreservedreservedreserved
ASCreservednon-reservednon-reservedreserved
ASENSITIVE reservedreserved
ASSERTIONnon-reservednon-reservednon-reservedreserved
ASSIGNMENTnon-reservednon-reservednon-reserved
ASYMMETRICreservedreservedreserved
ATnon-reservedreservedreservedreserved
ATOMIC reservedreserved
ATTACHnon-reserved
ATTRIBUTEnon-reservednon-reservednon-reserved
ATTRIBUTES non-reservednon-reserved
AUTHORIZATION保留(可以是功能或类型)reservedreservedreserved
AVG reservedreservedreserved
BACKWARDnon-reserved
BASE64 non-reservednon-reserved
BEFOREnon-reservednon-reservednon-reserved
BEGINnon-reservedreservedreservedreserved
BEGIN_FRAME reserved
BEGIN_PARTITION reserved
BERNOULLI non-reservednon-reserved
BETWEEN非保留(不能为函数或类型)reservedreservedreserved
BIGINT非保留(不能为函数或类型)reservedreserved
BINARY保留(可以是功能或类型)reservedreserved
BIT非保留(不能为函数或类型) reserved
BIT_LENGTH reserved
BLOB reservedreserved
BLOCKED non-reservednon-reserved
BOM non-reservednon-reserved
BOOLEAN非保留(不能为函数或类型)reservedreserved
BOTHreservedreservedreservedreserved
BREADTH non-reservednon-reserved
BYnon-reservedreservedreservedreserved
C non-reservednon-reservednon-reserved
CACHEnon-reserved
CALLnon-reservedreservedreserved
CALLEDnon-reservedreservedreserved
CARDINALITY reservedreserved
CASCADEnon-reservednon-reservednon-reservedreserved
CASCADEDnon-reservedreservedreservedreserved
CASEreservedreservedreservedreserved
CASTreservedreservedreservedreserved
CATALOGnon-reservednon-reservednon-reservedreserved
CATALOG_NAME non-reservednon-reservednon-reserved
CEIL reservedreserved
CEILING reservedreserved
CHAINnon-reservednon-reservednon-reserved
CHAR非保留(不能为函数或类型)reservedreservedreserved
CHARACTER非保留(不能为函数或类型)reservedreservedreserved
CHARACTERISTICSnon-reservednon-reservednon-reserved
CHARACTERS non-reservednon-reserved
CHARACTER_LENGTH reservedreservedreserved
CHARACTER_SET_CATALOG non-reservednon-reservednon-reserved
CHARACTER_SET_NAME non-reservednon-reservednon-reserved
CHARACTER_SET_SCHEMA non-reservednon-reservednon-reserved
CHAR_LENGTH reservedreservedreserved
CHECKreservedreservedreservedreserved
CHECKPOINTnon-reserved
CLASSnon-reserved
CLASS_ORIGIN non-reservednon-reservednon-reserved
CLOB reservedreserved
CLOSEnon-reservedreservedreservedreserved
CLUSTERnon-reserved
COALESCE非保留(不能为函数或类型)reservedreservedreserved
COBOL non-reservednon-reservednon-reserved
COLLATEreservedreservedreservedreserved
COLLATION保留(可以是功能或类型)non-reservednon-reservedreserved
COLLATION_CATALOG non-reservednon-reservednon-reserved
COLLATION_NAME non-reservednon-reservednon-reserved
COLLATION_SCHEMA non-reservednon-reservednon-reserved
COLLECT reservedreserved
COLUMNreservedreservedreservedreserved
COLUMNSnon-reservednon-reservednon-reserved
COLUMN_NAME non-reservednon-reservednon-reserved
COMMAND_FUNCTION non-reservednon-reservednon-reserved
COMMAND_FUNCTION_CODE non-reservednon-reserved
COMMENTnon-reserved
COMMENTSnon-reserved
COMMITnon-reservedreservedreservedreserved
COMMITTEDnon-reservednon-reservednon-reservednon-reserved
CONCURRENTLY保留(可以是功能或类型)
CONDITION reservedreserved
CONDITION_NUMBER non-reservednon-reservednon-reserved
CONFIGURATIONnon-reserved
CONFLICTnon-reserved
CONNECT reservedreservedreserved
CONNECTIONnon-reservednon-reservednon-reservedreserved
CONNECTION_NAME non-reservednon-reservednon-reserved
CONSTRAINTreservedreservedreservedreserved
CONSTRAINTSnon-reservednon-reservednon-reservedreserved
CONSTRAINT_CATALOG non-reservednon-reservednon-reserved
CONSTRAINT_NAME non-reservednon-reservednon-reserved
CONSTRAINT_SCHEMA non-reservednon-reservednon-reserved
CONSTRUCTOR non-reservednon-reserved
CONTAINS reservednon-reserved
CONTENTnon-reservednon-reservednon-reserved
CONTINUEnon-reservednon-reservednon-reservedreserved
CONTROL non-reservednon-reserved
CONVERSIONnon-reserved
CONVERT reservedreservedreserved
COPYnon-reserved
CORR reservedreserved
CORRESPONDING reservedreservedreserved
COSTnon-reserved
COUNT reservedreservedreserved
COVAR_POP reservedreserved
COVAR_SAMP reservedreserved
CREATEreservedreservedreservedreserved
CROSS保留(可以是功能或类型)reservedreservedreserved
CSVnon-reserved
CUBEnon-reservedreservedreserved
CUME_DIST reservedreserved
CURRENTnon-reservedreservedreservedreserved
CURRENT_CATALOGreservedreservedreserved
CURRENT_DATEreservedreservedreservedreserved
CURRENT_DEFAULT_TRANSFORM_GROUP reservedreserved
CURRENT_PATH reservedreserved
CURRENT_ROLEreservedreservedreserved
CURRENT_ROW reserved
CURRENT_SCHEMA保留(可以是功能或类型)reservedreserved
CURRENT_TIMEreservedreservedreservedreserved
CURRENT_TIMESTAMPreservedreservedreservedreserved
CURRENT_TRANSFORM_GROUP_FOR_TYPE reservedreserved
CURRENT_USERreservedreservedreservedreserved
CURSORnon-reservedreservedreservedreserved
CURSOR_NAME non-reservednon-reservednon-reserved
CYCLEnon-reservedreservedreserved
DATAnon-reservednon-reservednon-reservednon-reserved
DATABASEnon-reserved
DATALINK reservedreserved
DATE reservedreservedreserved
DATETIME_INTERVAL_CODE non-reservednon-reservednon-reserved
DATETIME_INTERVAL_PRECISION non-reservednon-reservednon-reserved
DAYnon-reservedreservedreservedreserved
DB non-reservednon-reserved
DEALLOCATEnon-reservedreservedreservedreserved
DEC非保留(不能为函数或类型)reservedreservedreserved
DECIMAL非保留(不能为函数或类型)reservedreservedreserved
DECLAREnon-reservedreservedreservedreserved
DEFAULTreservedreservedreservedreserved
DEFAULTSnon-reservednon-reservednon-reserved
DEFERRABLEreservednon-reservednon-reservedreserved
DEFERREDnon-reservednon-reservednon-reservedreserved
DEFINED non-reservednon-reserved
DEFINERnon-reservednon-reservednon-reserved
DEGREE non-reservednon-reserved
DELETEnon-reservedreservedreservedreserved
DELIMITERnon-reserved
DELIMITERSnon-reserved
DENSE_RANK reservedreserved
DEPENDSnon-reserved
DEPTH non-reservednon-reserved
DEREF reservedreserved
DERIVED non-reservednon-reserved
DESCreservednon-reservednon-reservedreserved
DESCRIBE reservedreservedreserved
DESCRIPTOR non-reservednon-reservedreserved
DETACHnon-reserved
DETERMINISTIC reservedreserved
DIAGNOSTICS non-reservednon-reservedreserved
DICTIONARYnon-reserved
DISABLEnon-reserved
DISCARDnon-reserved
DISCONNECT reservedreservedreserved
DISPATCH non-reservednon-reserved
DISTINCTreservedreservedreservedreserved
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-reservedreserved
DOUBLEnon-reservedreservedreservedreserved
DROPnon-reservedreservedreservedreserved
DYNAMIC reservedreserved
DYNAMIC_FUNCTION non-reservednon-reservednon-reserved
DYNAMIC_FUNCTION_CODE non-reservednon-reserved
EACHnon-reservedreservedreserved
ELEMENT reservedreserved
ELSEreservedreservedreservedreserved
EMPTY non-reservednon-reserved
ENABLEnon-reserved
ENCODINGnon-reservednon-reservednon-reserved
ENCRYPTEDnon-reserved
ENDreservedreservedreservedreserved
END-EXEC reservedreservedreserved
END_FRAME reserved
END_PARTITION reserved
ENFORCED non-reserved
ENUMnon-reserved
EQUALS reservednon-reserved
ESCAPEnon-reservedreservedreservedreserved
EVENTnon-reserved
EVERY reservedreserved
EXCEPTreservedreservedreservedreserved
EXCEPTION reserved
EXCLUDEnon-reservednon-reservednon-reserved
EXCLUDINGnon-reservednon-reservednon-reserved
EXCLUSIVEnon-reserved
EXEC reservedreservedreserved
EXECUTEnon-reservedreservedreservedreserved
EXISTS非保留(不能为函数或类型)reservedreservedreserved
EXP reservedreserved
EXPLAINnon-reserved
EXPRESSION non-reserved
EXTENSIONnon-reserved
EXTERNALnon-reservedreservedreservedreserved
EXTRACT非保留(不能为函数或类型)reservedreservedreserved
FALSEreservedreservedreservedreserved
FAMILYnon-reserved
FETCHreservedreservedreservedreserved
FILE non-reservednon-reserved
FILTERnon-reservedreservedreserved
FINAL non-reservednon-reserved
FIRSTnon-reservednon-reservednon-reservedreserved
FIRST_VALUE reservedreserved
FLAG non-reservednon-reserved
FLOAT非保留(不能为函数或类型)reservedreservedreserved
FLOOR reservedreserved
FOLLOWINGnon-reservednon-reservednon-reserved
FORreservedreservedreservedreserved
FORCEnon-reserved
FOREIGNreservedreservedreservedreserved
FORTRAN non-reservednon-reservednon-reserved
FORWARDnon-reserved
FOUND non-reservednon-reservedreserved
FRAME_ROW reserved
FREE reservedreserved
FREEZE保留(可以是功能或类型)
FROMreservedreservedreservedreserved
FS non-reservednon-reserved
FULL保留(可以是功能或类型)reservedreservedreserved
FUNCTIONnon-reservedreservedreserved
FUNCTIONSnon-reserved
FUSION reservedreserved
G non-reservednon-reserved
GENERAL non-reservednon-reserved
GENERATEDnon-reservednon-reservednon-reserved
GET reservedreservedreserved
GLOBALnon-reservedreservedreservedreserved
GO non-reservednon-reservedreserved
GOTO non-reservednon-reservedreserved
GRANTreservedreservedreservedreserved
GRANTEDnon-reservednon-reservednon-reserved
GREATEST非保留(不能为函数或类型)
GROUPreservedreservedreservedreserved
GROUPING非保留(不能为函数或类型)reservedreserved
GROUPSnon-reservedreserved
HANDLERnon-reserved
HAVINGreservedreservedreservedreserved
HEADERnon-reserved
HEX non-reservednon-reserved
HIERARCHY non-reservednon-reserved
HOLDnon-reservedreservedreserved
HOURnon-reservedreservedreservedreserved
ID non-reservednon-reserved
IDENTITYnon-reservedreservedreservedreserved
IFnon-reserved
IGNORE non-reservednon-reserved
ILIKE保留(可以是功能或类型)
IMMEDIATEnon-reservednon-reservednon-reservedreserved
IMMEDIATELY non-reserved
IMMUTABLEnon-reserved
IMPLEMENTATION non-reservednon-reserved
IMPLICITnon-reserved
IMPORTnon-reservedreservedreserved
INreservedreservedreservedreserved
INCLUDEnon-reserved
INCLUDINGnon-reservednon-reservednon-reserved
INCREMENTnon-reservednon-reservednon-reserved
INDENT non-reservednon-reserved
INDEXnon-reserved
INDEXESnon-reserved
INDICATOR reservedreservedreserved
INHERITnon-reserved
INHERITSnon-reserved
INITIALLYreservednon-reservednon-reservedreserved
INLINEnon-reserved
INNER保留(可以是功能或类型)reservedreservedreserved
INOUT非保留(不能为函数或类型)reservedreserved
INPUTnon-reservednon-reservednon-reservedreserved
INSENSITIVEnon-reservedreservedreservedreserved
INSERTnon-reservedreservedreservedreserved
INSTANCE non-reservednon-reserved
INSTANTIABLE non-reservednon-reserved
INSTEADnon-reservednon-reservednon-reserved
INT非保留(不能为函数或类型)reservedreservedreserved
INTEGER非保留(不能为函数或类型)reservedreservedreserved
INTEGRITY non-reservednon-reserved
INTERSECTreservedreservedreservedreserved
INTERSECTION reservedreserved
INTERVAL非保留(不能为函数或类型)reservedreservedreserved
INTOreservedreservedreservedreserved
INVOKERnon-reservednon-reservednon-reserved
IS保留(可以是功能或类型)reservedreservedreserved
ISNULL保留(可以是功能或类型)
ISOLATIONnon-reservednon-reservednon-reservedreserved
JOIN保留(可以是功能或类型)reservedreservedreserved
K non-reservednon-reserved
KEYnon-reservednon-reservednon-reservedreserved
KEY_MEMBER non-reservednon-reserved
KEY_TYPE non-reservednon-reserved
LABELnon-reserved
LAG reservedreserved
LANGUAGEnon-reservedreservedreservedreserved
LARGEnon-reservedreservedreserved
LASTnon-reservednon-reservednon-reservedreserved
LAST_VALUE reservedreserved
LATERALreservedreservedreserved
LEAD reservedreserved
LEADINGreservedreservedreservedreserved
LEAKPROOFnon-reserved
LEAST非保留(不能为函数或类型)
LEFT保留(可以是功能或类型)reservedreservedreserved
LENGTH non-reservednon-reservednon-reserved
LEVELnon-reservednon-reservednon-reservedreserved
LIBRARY non-reservednon-reserved
LIKE保留(可以是功能或类型)reservedreservedreserved
LIKE_REGEX reservedreserved
LIMITreservednon-reservednon-reserved
LINK non-reservednon-reserved
LISTENnon-reserved
LN reservedreserved
LOADnon-reserved
LOCALnon-reservedreservedreservedreserved
LOCALTIMEreservedreservedreserved
LOCALTIMESTAMPreservedreservedreserved
LOCATIONnon-reservednon-reservednon-reserved
LOCATOR non-reservednon-reserved
LOCKnon-reserved
LOCKEDnon-reserved
LOGGEDnon-reserved
LOWER reservedreservedreserved
M non-reservednon-reserved
MAP non-reservednon-reserved
MAPPINGnon-reservednon-reservednon-reserved
MATCHnon-reservedreservedreservedreserved
MATCHED non-reservednon-reserved
MATERIALIZEDnon-reserved
MAX reservedreservedreserved
MAXVALUEnon-reservednon-reservednon-reserved
MAX_CARDINALITY reserved
MEMBER reservedreserved
MERGE reservedreserved
MESSAGE_LENGTH non-reservednon-reservednon-reserved
MESSAGE_OCTET_LENGTH non-reservednon-reservednon-reserved
MESSAGE_TEXT non-reservednon-reservednon-reserved
METHODnon-reservedreservedreserved
MIN reservedreservedreserved
MINUTEnon-reservedreservedreservedreserved
MINVALUEnon-reservednon-reservednon-reserved
MOD reservedreserved
MODEnon-reserved
MODIFIES reservedreserved
MODULE reservedreservedreserved
MONTHnon-reservedreservedreservedreserved
MORE non-reservednon-reservednon-reserved
MOVEnon-reserved
MULTISET reservedreserved
MUMPS non-reservednon-reservednon-reserved
NAMEnon-reservednon-reservednon-reservednon-reserved
NAMESnon-reservednon-reservednon-reservedreserved
NAMESPACE non-reservednon-reserved
NATIONAL非保留(不能为函数或类型)reservedreservedreserved
NATURAL保留(可以是功能或类型)reservedreservedreserved
NCHAR非保留(不能为函数或类型)reservedreservedreserved
NCLOB reservedreserved
NESTING non-reservednon-reserved
NEWnon-reservedreservedreserved
NEXTnon-reservednon-reservednon-reservedreserved
NFC non-reservednon-reserved
NFD non-reservednon-reserved
NFKC non-reservednon-reserved
NFKD non-reservednon-reserved
NIL non-reservednon-reserved
NOnon-reservedreservedreservedreserved
NONE非保留(不能为函数或类型)reservedreserved
NORMALIZE reservedreserved
NORMALIZED non-reservednon-reserved
NOTreservedreservedreservedreserved
NOTHINGnon-reserved
NOTIFYnon-reserved
NOTNULL保留(可以是功能或类型)
NOWAITnon-reserved
NTH_VALUE reservedreserved
NTILE reservedreserved
NULLreservedreservedreservedreserved
NULLABLE non-reservednon-reservednon-reserved
NULLIF非保留(不能为函数或类型)reservedreservedreserved
NULLSnon-reservednon-reservednon-reserved
NUMBER non-reservednon-reservednon-reserved
NUMERIC非保留(不能为函数或类型)reservedreservedreserved
OBJECTnon-reservednon-reservednon-reserved
OCCURRENCES_REGEX reservedreserved
OCTETS non-reservednon-reserved
OCTET_LENGTH reservedreservedreserved
OFnon-reservedreservedreservedreserved
OFFnon-reservednon-reservednon-reserved
OFFSETreservedreservedreserved
OIDSnon-reserved
OLDnon-reservedreservedreserved
ONreservedreservedreservedreserved
ONLYreservedreservedreservedreserved
OPEN reservedreservedreserved
OPERATORnon-reserved
OPTIONnon-reservednon-reservednon-reservedreserved
OPTIONSnon-reservednon-reservednon-reserved
ORreservedreservedreservedreserved
ORDERreservedreservedreservedreserved
ORDERING non-reservednon-reserved
ORDINALITYnon-reservednon-reservednon-reserved
OTHERSnon-reservednon-reservednon-reserved
OUT非保留(不能为函数或类型)reservedreserved
OUTER保留(可以是功能或类型)reservedreservedreserved
OUTPUT non-reservednon-reservedreserved
OVERnon-reservedreservedreserved
OVERLAPS保留(可以是功能或类型)reservedreservedreserved
OVERLAY非保留(不能为函数或类型)reservedreserved
OVERRIDINGnon-reservednon-reservednon-reserved
OWNEDnon-reserved
OWNERnon-reserved
P non-reservednon-reserved
PAD non-reservednon-reservedreserved
PARALLELnon-reserved
PARAMETER reservedreserved
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-reservednon-reservedreserved
PARTITIONnon-reservedreservedreserved
PASCAL non-reservednon-reservednon-reserved
PASSINGnon-reservednon-reservednon-reserved
PASSTHROUGH non-reservednon-reserved
PASSWORDnon-reserved
PATH non-reservednon-reserved
PERCENT reserved
PERCENTILE_CONT reservedreserved
PERCENTILE_DISC reservedreserved
PERCENT_RANK reservedreserved
PERIOD reserved
PERMISSION non-reservednon-reserved
PLACINGreservednon-reservednon-reserved
PLANSnon-reserved
PLI non-reservednon-reservednon-reserved
POLICYnon-reserved
PORTION reserved
POSITION非保留(不能为函数或类型)reservedreservedreserved
POSITION_REGEX reservedreserved
POWER reservedreserved
PRECEDES reserved
PRECEDINGnon-reservednon-reservednon-reserved
PRECISION非保留(不能为函数或类型)reservedreservedreserved
PREPAREnon-reservedreservedreservedreserved
PREPAREDnon-reserved
PRESERVEnon-reservednon-reservednon-reservedreserved
PRIMARYreservedreservedreservedreserved
PRIORnon-reservednon-reservednon-reservedreserved
PRIVILEGESnon-reservednon-reservednon-reservedreserved
PROCEDURALnon-reserved
PROCEDUREnon-reservedreservedreservedreserved
PROCEDURESnon-reserved
PROGRAMnon-reserved
PUBLIC non-reservednon-reservedreserved
PUBLICATIONnon-reserved
QUOTEnon-reserved
RANGEnon-reservedreservedreserved
RANK reservedreserved
READnon-reservednon-reservednon-reservedreserved
READS reservedreserved
REAL非保留(不能为函数或类型)reservedreservedreserved
REASSIGNnon-reserved
RECHECKnon-reserved
RECOVERY non-reservednon-reserved
RECURSIVEnon-reservedreservedreserved
REFnon-reservedreservedreserved
REFERENCESreservedreservedreservedreserved
REFERENCINGnon-reservedreservedreserved
REFRESHnon-reserved
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-reservedreserved
RELEASEnon-reservedreservedreserved
RENAMEnon-reserved
REPEATABLEnon-reservednon-reservednon-reservednon-reserved
REPLACEnon-reserved
REPLICAnon-reserved
REQUIRING non-reservednon-reserved
RESETnon-reserved
RESPECT non-reservednon-reserved
RESTARTnon-reservednon-reservednon-reserved
RESTORE non-reservednon-reserved
RESTRICTnon-reservednon-reservednon-reservedreserved
RESULT reservedreserved
RETURN reservedreserved
RETURNED_CARDINALITY non-reservednon-reserved
RETURNED_LENGTH non-reservednon-reservednon-reserved
RETURNED_OCTET_LENGTH non-reservednon-reservednon-reserved
RETURNED_SQLSTATE non-reservednon-reservednon-reserved
RETURNINGreservednon-reservednon-reserved
RETURNSnon-reservedreservedreserved
REVOKEnon-reservedreservedreservedreserved
RIGHT保留(可以是功能或类型)reservedreservedreserved
ROLEnon-reservednon-reservednon-reserved
ROLLBACKnon-reservedreservedreservedreserved
ROLLUPnon-reservedreservedreserved
ROUTINEnon-reservednon-reservednon-reserved
ROUTINESnon-reserved
ROUTINE_CATALOG non-reservednon-reserved
ROUTINE_NAME non-reservednon-reserved
ROUTINE_SCHEMA non-reservednon-reserved
ROW非保留(不能为函数或类型)reservedreserved
ROWSnon-reservedreservedreservedreserved
ROW_COUNT non-reservednon-reservednon-reserved
ROW_NUMBER reservedreserved
RULEnon-reserved
SAVEPOINTnon-reservedreservedreserved
SCALE non-reservednon-reservednon-reserved
SCHEMAnon-reservednon-reservednon-reservedreserved
SCHEMASnon-reserved
SCHEMA_NAME non-reservednon-reservednon-reserved
SCOPE reservedreserved
SCOPE_CATALOG non-reservednon-reserved
SCOPE_NAME non-reservednon-reserved
SCOPE_SCHEMA non-reservednon-reserved
SCROLLnon-reservedreservedreservedreserved
SEARCHnon-reservedreservedreserved
SECONDnon-reservedreservedreservedreserved
SECTION non-reservednon-reservedreserved
SECURITYnon-reservednon-reservednon-reserved
SELECTreservedreservedreservedreserved
SELECTIVE non-reservednon-reserved
SELF non-reservednon-reserved
SENSITIVE reservedreserved
SEQUENCEnon-reservednon-reservednon-reserved
SEQUENCESnon-reserved
SERIALIZABLEnon-reservednon-reservednon-reservednon-reserved
SERVERnon-reservednon-reservednon-reserved
SERVER_NAME non-reservednon-reservednon-reserved
SESSIONnon-reservednon-reservednon-reservedreserved
SESSION_USERreservedreservedreservedreserved
SETnon-reservedreservedreservedreserved
SETOF非保留(不能为函数或类型)
SETSnon-reservednon-reservednon-reserved
SHAREnon-reserved
SHOWnon-reserved
SIMILAR保留(可以是功能或类型)reservedreserved
SIMPLEnon-reservednon-reservednon-reserved
SIZE non-reservednon-reservedreserved
SKIPnon-reserved
SMALLINT非保留(不能为函数或类型)reservedreservedreserved
SNAPSHOTnon-reserved
SOMEreservedreservedreservedreserved
SOURCE non-reservednon-reserved
SPACE non-reservednon-reservedreserved
SPECIFIC reservedreserved
SPECIFICTYPE reservedreserved
SPECIFIC_NAME non-reservednon-reserved
SQLnon-reservedreservedreservedreserved
SQLCODE reserved
SQLERROR reserved
SQLEXCEPTION reservedreserved
SQLSTATE reservedreservedreserved
SQLWARNING reservedreserved
SQRT reservedreserved
STABLEnon-reserved
STANDALONEnon-reservednon-reservednon-reserved
STARTnon-reservedreservedreserved
STATE non-reservednon-reserved
STATEMENTnon-reservednon-reservednon-reserved
STATIC reservedreserved
STATISTICSnon-reserved
STDDEV_POP reservedreserved
STDDEV_SAMP reservedreserved
STDINnon-reserved
STDOUTnon-reserved
STORAGEnon-reserved
STRICTnon-reserved
STRIPnon-reservednon-reservednon-reserved
STRUCTURE non-reservednon-reserved
STYLE non-reservednon-reserved
SUBCLASS_ORIGIN non-reservednon-reservednon-reserved
SUBMULTISET reservedreserved
SUBSCRIPTIONnon-reserved
SUBSTRING非保留(不能为函数或类型)reservedreservedreserved
SUBSTRING_REGEX reservedreserved
SUCCEEDS reserved
SUM reservedreservedreserved
SYMMETRICreservedreservedreserved
SYSIDnon-reserved
SYSTEMnon-reservedreservedreserved
SYSTEM_TIME reserved
SYSTEM_USER reservedreservedreserved
T non-reservednon-reserved
TABLEreservedreservedreservedreserved
TABLESnon-reserved
TABLESAMPLE保留(可以是功能或类型)reservedreserved
TABLESPACEnon-reserved
TABLE_NAME non-reservednon-reservednon-reserved
TEMPnon-reserved
TEMPLATEnon-reserved
TEMPORARYnon-reservednon-reservednon-reservedreserved
TEXTnon-reserved
THENreservedreservedreservedreserved
TIESnon-reservednon-reservednon-reserved
TIME非保留(不能为函数或类型)reservedreservedreserved
TIMESTAMP非保留(不能为函数或类型)reservedreservedreserved
TIMEZONE_HOUR reservedreservedreserved
TIMEZONE_MINUTE reservedreservedreserved
TOreservedreservedreservedreserved
TOKEN non-reservednon-reserved
TOP_LEVEL_COUNT non-reservednon-reserved
TRAILINGreservedreservedreservedreserved
TRANSACTIONnon-reservednon-reservednon-reservedreserved
TRANSACTIONS_COMMITTED non-reservednon-reserved
TRANSACTIONS_ROLLED_BACK non-reservednon-reserved
TRANSACTION_ACTIVE non-reservednon-reserved
TRANSFORMnon-reservednon-reservednon-reserved
TRANSFORMS non-reservednon-reserved
TRANSLATE reservedreservedreserved
TRANSLATE_REGEX reservedreserved
TRANSLATION reservedreservedreserved
TREAT非保留(不能为函数或类型)reservedreserved
TRIGGERnon-reservedreservedreserved
TRIGGER_CATALOG non-reservednon-reserved
TRIGGER_NAME non-reservednon-reserved
TRIGGER_SCHEMA non-reservednon-reserved
TRIM非保留(不能为函数或类型)reservedreservedreserved
TRIM_ARRAY reservedreserved
TRUEreservedreservedreservedreserved
TRUNCATEnon-reservedreservedreserved
TRUSTEDnon-reserved
TYPEnon-reservednon-reservednon-reservednon-reserved
TYPESnon-reserved
UESCAPE reservedreserved
UNBOUNDEDnon-reservednon-reservednon-reserved
UNCOMMITTEDnon-reservednon-reservednon-reservednon-reserved
UNDER non-reservednon-reserved
UNENCRYPTEDnon-reserved
UNIONreservedreservedreservedreserved
UNIQUEreservedreservedreservedreserved
UNKNOWNnon-reservedreservedreservedreserved
UNLINK non-reservednon-reserved
UNLISTENnon-reserved
UNLOGGEDnon-reserved
UNNAMED non-reservednon-reservednon-reserved
UNNEST reservedreserved
UNTILnon-reserved
UNTYPED non-reservednon-reserved
UPDATEnon-reservedreservedreservedreserved
UPPER reservedreservedreserved
URI non-reservednon-reserved
USAGE non-reservednon-reservedreserved
USERreservedreservedreservedreserved
USER_DEFINED_TYPE_CATALOG non-reservednon-reserved
USER_DEFINED_TYPE_CODE non-reservednon-reserved
USER_DEFINED_TYPE_NAME non-reservednon-reserved
USER_DEFINED_TYPE_SCHEMA non-reservednon-reserved
USINGreservedreservedreservedreserved
VACUUMnon-reserved
VALIDnon-reservednon-reservednon-reserved
VALIDATEnon-reserved
VALIDATORnon-reserved
VALUEnon-reservedreservedreservedreserved
VALUES非保留(不能为函数或类型)reservedreservedreserved
VALUE_OF reserved
VARBINARY reservedreserved
VARCHAR非保留(不能为函数或类型)reservedreservedreserved
VARIADICreserved
VARYINGnon-reservedreservedreservedreserved
VAR_POP reservedreserved
VAR_SAMP reservedreserved
VERBOSE保留(可以是功能或类型)
VERSIONnon-reservednon-reservednon-reserved
VERSIONING reserved
VIEWnon-reservednon-reservednon-reservedreserved
VIEWSnon-reserved
VOLATILEnon-reserved
WHENreservedreservedreservedreserved
WHENEVER reservedreservedreserved
WHEREreservedreservedreservedreserved
WHITESPACEnon-reservednon-reservednon-reserved
WIDTH_BUCKET reservedreserved
WINDOWreservedreservedreserved
WITHreservedreservedreservedreserved
WITHINnon-reservedreservedreserved
WITHOUTnon-reservedreservedreserved
WORKnon-reservednon-reservednon-reservedreserved
WRAPPERnon-reservednon-reservednon-reserved
WRITEnon-reservednon-reservednon-reservedreserved
XMLnon-reservedreservedreserved
XMLAGG reservedreserved
XMLATTRIBUTES非保留(不能为函数或类型)reservedreserved
XMLBINARY reservedreserved
XMLCAST reservedreserved
XMLCOMMENT reservedreserved
XMLCONCAT非保留(不能为函数或类型)reservedreserved
XMLDECLARATION non-reservednon-reserved
XMLDOCUMENT reservedreserved
XMLELEMENT非保留(不能为函数或类型)reservedreserved
XMLEXISTS非保留(不能为函数或类型)reservedreserved
XMLFOREST非保留(不能为函数或类型)reservedreserved
XMLITERATE reservedreserved
XMLNAMESPACES非保留(不能为函数或类型)reservedreserved
XMLPARSE非保留(不能为函数或类型)reservedreserved
XMLPI非保留(不能为函数或类型)reservedreserved
XMLQUERY reservedreserved
XMLROOT非保留(不能为函数或类型)
XMLSCHEMA non-reservednon-reserved
XMLSERIALIZE非保留(不能为函数或类型)reservedreserved
XMLTABLE非保留(不能为函数或类型)reservedreserved
XMLTEXT reservedreserved
XMLVALIDATE reservedreserved
YEARnon-reservedreservedreservedreserved
YESnon-reservednon-reservednon-reserved
ZONEnon-reservednon-reservednon-reservedreserved