Postgresql 中文操作指南
Appendix C. SQL Key Words
Table C.1 列出了 SQL 标准和 PostgreSQL 16.3 中的所有关键字标记。 Section 4.1.1 中可找到背景信息。（出于节省空间的考虑，仅包含最新两个版本的 SQL 标准以及出于历史比较目的的 SQL-92。其他中间标准版本与这些版本之间的差异很小。）
SQL 区分 reserved 和 non-reserved 关键字。根据该标准，保留的关键字是唯一真正的关键字；它们绝不会被允许作为标识符。非保留关键字仅在特定上下文中具有特殊含义，且可以在其他上下文中用作标识符。大多数非保留关键字实际上都是 SQL 指定的内置表和函数的名称。非保留关键字的概念实质上仅存在于声明在某些上下文中为某个单词附加了某种预定义含义。
在 PostgreSQL 解析器中，生命要复杂一些。有几类不同的标记，从永远无法用作标识符的标记到在解析器中绝对没有特殊状态但被视为普通标识符的标记（对于 SQL 指定的函数通常就是这种情况）。甚至保留关键字在 PostgreSQL 中也不是完全保留的，但可以使用作为列标签（例如 SELECT 55 AS CHECK ，即使 CHECK 是一个保留关键字）。
在 Table C.1 中的 PostgreSQL 列中，我们将其显式解析器所知但允许作为列或表名称的关键字归类为“非保留”。某些在其他情况下是非保留的关键字不能用作函数或数据类型名称，并会相应地标记。（这些单词中的大多数表示具有特殊语法的内置函数或数据类型。函数或类型仍然可用，但不能被用户重新定义。）标记为“保留”的是那些不被允许作为列或表名称的标记。某些保留关键字允许作为函数或数据类型的名称；这也会显示在表中。如果没有此标记，则保留关键字仅允许作为列标签。此列中的空条目表示 PostgreSQL 将该单词视为普通标识符。
此外，虽然大多数关键字可以用作“裸”列标签而不必在它们前面写入 AS （如 Section 7.3.2 中所述），但有几个关键字需要前导 AS 以避免歧义。表中将它们标记为“需要 AS ”。
作为一个通用规则，如果你对使用所列任何关键字作为标识符的命令获得虚假的解析器错误，你应尝试引用标识符来查看问题是否消失。
在研究 Table C.1 之前，了解以下事实很重要：关键字在 PostgreSQL 中没有被保留并不意味着与该单词相关的特性未被实现。相反，关键字的存在并不表示存在特性。
Table C.1. SQL Key Words
Key Word |
PostgreSQL |
SQL:2023 |
SQL:2016 |
SQL-92 |
A |
non-reserved |
non-reserved |
||
ABORT |
non-reserved |
|||
ABS |
reserved |
reserved |
||
ABSENT |
non-reserved |
reserved |
reserved |
|
ABSOLUTE |
non-reserved |
non-reserved |
non-reserved |
reserved |
ACCESS |
non-reserved |
|||
ACCORDING |
non-reserved |
non-reserved |
||
ACOS |
reserved |
reserved |
||
ACTION |
non-reserved |
non-reserved |
non-reserved |
reserved |
ADA |
non-reserved |
non-reserved |
non-reserved |
|
ADD |
non-reserved |
non-reserved |
non-reserved |
reserved |
ADMIN |
non-reserved |
non-reserved |
non-reserved |
|
AFTER |
non-reserved |
non-reserved |
non-reserved |
|
AGGREGATE |
non-reserved |
|||
ALL |
reserved |
reserved |
reserved |
reserved |
ALLOCATE |
reserved |
reserved |
reserved |
|
ALSO |
non-reserved |
|||
ALTER |
non-reserved |
reserved |
reserved |
reserved |
ALWAYS |
non-reserved |
non-reserved |
non-reserved |
|
ANALYSE |
reserved |
|||
ANALYZE |
reserved |
|||
AND |
reserved |
reserved |
reserved |
reserved |
ANY |
reserved |
reserved |
reserved |
reserved |
ANY_VALUE |
reserved |
|||
ARE |
reserved |
reserved |
reserved |
|
ARRAY |
reserved, requires AS |
reserved |
reserved |
|
ARRAY_AGG |
reserved |
reserved |
||
ARRAYMAX_CARDINALITY_ |
reserved |
reserved |
||
AS |
reserved, requires AS |
reserved |
reserved |
reserved |
ASC |
reserved |
non-reserved |
non-reserved |
reserved |
ASENSITIVE |
non-reserved |
reserved |
reserved |
|
ASIN |
reserved |
reserved |
||
ASSERTION |
non-reserved |
non-reserved |
non-reserved |
reserved |
ASSIGNMENT |
non-reserved |
non-reserved |
non-reserved |
|
ASYMMETRIC |
reserved |
reserved |
reserved |
|
AT |
non-reserved |
reserved |
reserved |
reserved |
ATAN |
reserved |
reserved |
||
ATOMIC |
non-reserved |
reserved |
reserved |
|
ATTACH |
non-reserved |
|||
ATTRIBUTE |
non-reserved |
non-reserved |
non-reserved |
|
ATTRIBUTES |
non-reserved |
non-reserved |
||
AUTHORIZATION |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
AVG |
reserved |
reserved |
reserved |
|
BACKWARD |
non-reserved |
|||
BASE64 |
non-reserved |
non-reserved |
||
BEFORE |
non-reserved |
non-reserved |
non-reserved |
|
BEGIN |
non-reserved |
reserved |
reserved |
reserved |
BEGIN_FRAME |
reserved |
reserved |
||
BEGIN_PARTITION |
reserved |
reserved |
||
BERNOULLI |
non-reserved |
non-reserved |
||
BETWEEN |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
BIGINT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
BINARY |
保留（可以是函数或类型） |
reserved |
reserved |
|
BIT |
非保留（不能是函数或类型） |
reserved |
||
BIT_LENGTH |
reserved |
|||
BLOB |
reserved |
reserved |
||
BLOCKED |
non-reserved |
non-reserved |
||
BOM |
non-reserved |
non-reserved |
||
BOOLEAN |
非保留（不能是函数或类型） |
reserved |
reserved |
|
BOTH |
reserved |
reserved |
reserved |
reserved |
BREADTH |
non-reserved |
non-reserved |
non-reserved |
|
BTRIM |
reserved |
|||
BY |
non-reserved |
reserved |
reserved |
reserved |
C |
non-reserved |
non-reserved |
non-reserved |
|
CACHE |
non-reserved |
|||
CALL |
non-reserved |
reserved |
reserved |
|
CALLED |
non-reserved |
reserved |
reserved |
|
CARDINALITY |
reserved |
reserved |
||
CASCADE |
non-reserved |
non-reserved |
non-reserved |
reserved |
CASCADED |
non-reserved |
reserved |
reserved |
reserved |
CASE |
reserved |
reserved |
reserved |
reserved |
CAST |
reserved |
reserved |
reserved |
reserved |
CATALOG |
non-reserved |
non-reserved |
non-reserved |
reserved |
CATALOG_NAME |
non-reserved |
non-reserved |
non-reserved |
|
CEIL |
reserved |
reserved |
||
CEILING |
reserved |
reserved |
||
CHAIN |
non-reserved |
non-reserved |
non-reserved |
|
CHAINING |
non-reserved |
non-reserved |
||
CHAR |
非保留（不能是函数或类型），需要 AS |
reserved |
reserved |
reserved |
CHARACTER |
非保留（不能是函数或类型），需要 AS |
reserved |
reserved |
reserved |
CHARACTERISTICS |
non-reserved |
non-reserved |
non-reserved |
|
CHARACTERS |
non-reserved |
non-reserved |
||
CHARACTER_LENGTH |
reserved |
reserved |
reserved |
|
CHARACTERSET_CATALOG_ |
non-reserved |
non-reserved |
non-reserved |
|
CHARACTER_SET_NAME |
non-reserved |
non-reserved |
non-reserved |
|
CHARACTER_SET_SCHEMA |
non-reserved |
non-reserved |
non-reserved |
|
CHAR_LENGTH |
reserved |
reserved |
reserved |
|
CHECK |
reserved |
reserved |
reserved |
reserved |
CHECKPOINT |
non-reserved |
|||
CLASS |
non-reserved |
|||
CLASSIFIER |
reserved |
reserved |
||
CLASS_ORIGIN |
non-reserved |
non-reserved |
non-reserved |
|
CLOB |
reserved |
reserved |
||
CLOSE |
non-reserved |
reserved |
reserved |
reserved |
CLUSTER |
non-reserved |
|||
COALESCE |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
COBOL |
non-reserved |
non-reserved |
non-reserved |
|
COLLATE |
reserved |
reserved |
reserved |
reserved |
COLLATION |
保留（可以是函数或类型） |
non-reserved |
non-reserved |
reserved |
COLLATION_CATALOG |
non-reserved |
non-reserved |
non-reserved |
|
COLLATION_NAME |
non-reserved |
non-reserved |
non-reserved |
|
COLLATION_SCHEMA |
non-reserved |
non-reserved |
non-reserved |
|
COLLECT |
reserved |
reserved |
||
COLUMN |
reserved |
reserved |
reserved |
reserved |
COLUMNS |
non-reserved |
non-reserved |
non-reserved |
|
COLUMN_NAME |
non-reserved |
non-reserved |
non-reserved |
|
COMMAND_FUNCTION |
non-reserved |
non-reserved |
non-reserved |
|
COMMANDFUNCTION_CODE_ |
non-reserved |
non-reserved |
||
COMMENT |
non-reserved |
|||
COMMENTS |
non-reserved |
|||
COMMIT |
non-reserved |
reserved |
reserved |
reserved |
COMMITTED |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
COMPRESSION |
non-reserved |
|||
CONCURRENTLY |
保留（可以是函数或类型） |
|||
CONDITION |
reserved |
reserved |
||
CONDITIONAL |
non-reserved |
non-reserved |
||
CONDITION_NUMBER |
non-reserved |
non-reserved |
non-reserved |
|
CONFIGURATION |
non-reserved |
|||
CONFLICT |
non-reserved |
|||
CONNECT |
reserved |
reserved |
reserved |
|
CONNECTION |
non-reserved |
non-reserved |
non-reserved |
reserved |
CONNECTION_NAME |
non-reserved |
non-reserved |
non-reserved |
|
CONSTRAINT |
reserved |
reserved |
reserved |
reserved |
CONSTRAINTS |
non-reserved |
non-reserved |
non-reserved |
reserved |
CONSTRAINT_CATALOG |
non-reserved |
non-reserved |
non-reserved |
|
CONSTRAINT_NAME |
non-reserved |
non-reserved |
non-reserved |
|
CONSTRAINT_SCHEMA |
non-reserved |
non-reserved |
non-reserved |
|
CONSTRUCTOR |
non-reserved |
non-reserved |
||
CONTAINS |
reserved |
reserved |
||
CONTENT |
non-reserved |
non-reserved |
non-reserved |
|
CONTINUE |
non-reserved |
non-reserved |
non-reserved |
reserved |
CONTROL |
non-reserved |
non-reserved |
||
CONVERSION |
non-reserved |
|||
CONVERT |
reserved |
reserved |
reserved |
|
COPARTITION |
non-reserved |
|||
COPY |
non-reserved |
reserved |
reserved |
|
CORR |
reserved |
reserved |
||
CORRESPONDING |
reserved |
reserved |
reserved |
|
COS |
reserved |
reserved |
||
COSH |
reserved |
reserved |
||
COST |
non-reserved |
|||
COUNT |
reserved |
reserved |
reserved |
|
COVAR_POP |
reserved |
reserved |
||
COVAR_SAMP |
reserved |
reserved |
||
CREATE |
reserved, requires AS |
reserved |
reserved |
reserved |
CROSS |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
CSV |
non-reserved |
|||
CUBE |
non-reserved |
reserved |
reserved |
|
CUME_DIST |
reserved |
reserved |
||
CURRENT |
non-reserved |
reserved |
reserved |
reserved |
CURRENT_CATALOG |
reserved |
reserved |
reserved |
|
CURRENT_DATE |
reserved |
reserved |
reserved |
reserved |
CURRENTDEFAULT_TRANSFORM_GROUP_ |
reserved |
reserved |
||
CURRENT_PATH |
reserved |
reserved |
||
CURRENT_ROLE |
reserved |
reserved |
reserved |
|
CURRENT_ROW |
reserved |
reserved |
||
CURRENT_SCHEMA |
保留（可以是函数或类型） |
reserved |
reserved |
|
CURRENT_TIME |
reserved |
reserved |
reserved |
reserved |
CURRENT_TIMESTAMP |
reserved |
reserved |
reserved |
reserved |
CURRENTTRANSFORM_GROUP_FOR_TYPE_ |
reserved |
reserved |
||
CURRENT_USER |
reserved |
reserved |
reserved |
reserved |
CURSOR |
non-reserved |
reserved |
reserved |
reserved |
CURSOR_NAME |
non-reserved |
non-reserved |
non-reserved |
|
CYCLE |
non-reserved |
reserved |
reserved |
|
DATA |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
DATABASE |
non-reserved |
|||
DATALINK |
reserved |
reserved |
||
DATE |
reserved |
reserved |
reserved |
|
DATETIMEINTERVAL_CODE_ |
non-reserved |
non-reserved |
non-reserved |
|
DATETIMEINTERVAL_PRECISION_ |
non-reserved |
non-reserved |
non-reserved |
|
DAY |
non-reserved, requires AS |
reserved |
reserved |
reserved |
DB |
non-reserved |
non-reserved |
||
DEALLOCATE |
non-reserved |
reserved |
reserved |
reserved |
DEC |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
DECFLOAT |
reserved |
reserved |
||
DECIMAL |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
DECLARE |
non-reserved |
reserved |
reserved |
reserved |
DEFAULT |
reserved |
reserved |
reserved |
reserved |
DEFAULTS |
non-reserved |
non-reserved |
non-reserved |
|
DEFERRABLE |
reserved |
non-reserved |
non-reserved |
reserved |
DEFERRED |
non-reserved |
non-reserved |
non-reserved |
reserved |
DEFINE |
reserved |
reserved |
||
DEFINED |
non-reserved |
non-reserved |
||
DEFINER |
non-reserved |
non-reserved |
non-reserved |
|
DEGREE |
non-reserved |
non-reserved |
||
DELETE |
non-reserved |
reserved |
reserved |
reserved |
DELIMITER |
non-reserved |
|||
DELIMITERS |
non-reserved |
|||
DENSE_RANK |
reserved |
reserved |
||
DEPENDS |
non-reserved |
|||
DEPTH |
non-reserved |
non-reserved |
non-reserved |
|
DEREF |
reserved |
reserved |
||
DERIVED |
non-reserved |
non-reserved |
||
DESC |
reserved |
non-reserved |
non-reserved |
reserved |
DESCRIBE |
reserved |
reserved |
reserved |
|
DESCRIPTOR |
non-reserved |
non-reserved |
reserved |
|
DETACH |
non-reserved |
|||
DETERMINISTIC |
reserved |
reserved |
||
DIAGNOSTICS |
non-reserved |
non-reserved |
reserved |
|
DICTIONARY |
non-reserved |
|||
DISABLE |
non-reserved |
|||
DISCARD |
non-reserved |
|||
DISCONNECT |
reserved |
reserved |
reserved |
|
DISPATCH |
non-reserved |
non-reserved |
||
DISTINCT |
reserved |
reserved |
reserved |
reserved |
DLNEWCOPY |
reserved |
reserved |
||
DLPREVIOUSCOPY |
reserved |
reserved |
||
DLURLCOMPLETE |
reserved |
reserved |
||
DLURLCOMPLETEONLY |
reserved |
reserved |
||
DLURLCOMPLETEWRITE |
reserved |
reserved |
||
DLURLPATH |
reserved |
reserved |
||
DLURLPATHONLY |
reserved |
reserved |
||
DLURLPATHWRITE |
reserved |
reserved |
||
DLURLSCHEME |
reserved |
reserved |
||
DLURLSERVER |
reserved |
reserved |
||
DLVALUE |
reserved |
reserved |
||
DO |
reserved |
|||
DOCUMENT |
non-reserved |
non-reserved |
non-reserved |
|
DOMAIN |
non-reserved |
non-reserved |
non-reserved |
reserved |
DOUBLE |
non-reserved |
reserved |
reserved |
reserved |
DROP |
non-reserved |
reserved |
reserved |
reserved |
DYNAMIC |
reserved |
reserved |
||
DYNAMIC_FUNCTION |
non-reserved |
non-reserved |
non-reserved |
|
DYNAMICFUNCTION_CODE_ |
non-reserved |
non-reserved |
||
EACH |
non-reserved |
reserved |
reserved |
|
ELEMENT |
reserved |
reserved |
||
ELSE |
reserved |
reserved |
reserved |
reserved |
EMPTY |
reserved |
reserved |
||
ENABLE |
non-reserved |
|||
ENCODING |
non-reserved |
non-reserved |
non-reserved |
|
ENCRYPTED |
non-reserved |
|||
END |
reserved |
reserved |
reserved |
reserved |
END-EXEC |
reserved |
reserved |
reserved |
|
END_FRAME |
reserved |
reserved |
||
END_PARTITION |
reserved |
reserved |
||
ENFORCED |
non-reserved |
non-reserved |
||
ENUM |
non-reserved |
|||
EQUALS |
reserved |
reserved |
||
ERROR |
non-reserved |
non-reserved |
||
ESCAPE |
non-reserved |
reserved |
reserved |
reserved |
EVENT |
non-reserved |
|||
EVERY |
reserved |
reserved |
||
EXCEPT |
reserved, requires AS |
reserved |
reserved |
reserved |
EXCEPTION |
reserved |
|||
EXCLUDE |
non-reserved |
non-reserved |
non-reserved |
|
EXCLUDING |
non-reserved |
non-reserved |
non-reserved |
|
EXCLUSIVE |
non-reserved |
|||
EXEC |
reserved |
reserved |
reserved |
|
EXECUTE |
non-reserved |
reserved |
reserved |
reserved |
EXISTS |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
EXP |
reserved |
reserved |
||
EXPLAIN |
non-reserved |
|||
EXPRESSION |
non-reserved |
non-reserved |
non-reserved |
|
EXTENSION |
non-reserved |
|||
EXTERNAL |
non-reserved |
reserved |
reserved |
reserved |
EXTRACT |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
FALSE |
reserved |
reserved |
reserved |
reserved |
FAMILY |
non-reserved |
|||
FETCH |
reserved, requires AS |
reserved |
reserved |
reserved |
FILE |
non-reserved |
non-reserved |
||
FILTER |
non-reserved, requires AS |
reserved |
reserved |
|
FINAL |
non-reserved |
non-reserved |
||
FINALIZE |
non-reserved |
|||
FINISH |
non-reserved |
non-reserved |
||
FIRST |
non-reserved |
non-reserved |
non-reserved |
reserved |
FIRST_VALUE |
reserved |
reserved |
||
FLAG |
non-reserved |
non-reserved |
||
FLOAT |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
FLOOR |
reserved |
reserved |
||
FOLLOWING |
non-reserved |
non-reserved |
non-reserved |
|
FOR |
reserved, requires AS |
reserved |
reserved |
reserved |
FORCE |
non-reserved |
|||
FOREIGN |
reserved |
reserved |
reserved |
reserved |
FORMAT |
non-reserved |
non-reserved |
non-reserved |
|
FORTRAN |
non-reserved |
non-reserved |
non-reserved |
|
FORWARD |
non-reserved |
|||
FOUND |
non-reserved |
non-reserved |
reserved |
|
FRAME_ROW |
reserved |
reserved |
||
FREE |
reserved |
reserved |
||
FREEZE |
保留（可以是函数或类型） |
|||
FROM |
reserved, requires AS |
reserved |
reserved |
reserved |
FS |
non-reserved |
non-reserved |
||
FULFILL |
non-reserved |
non-reserved |
||
FULL |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
FUNCTION |
non-reserved |
reserved |
reserved |
|
FUNCTIONS |
non-reserved |
|||
FUSION |
reserved |
reserved |
||
G |
non-reserved |
non-reserved |
||
GENERAL |
non-reserved |
non-reserved |
||
GENERATED |
non-reserved |
non-reserved |
non-reserved |
|
GET |
reserved |
reserved |
reserved |
|
GLOBAL |
non-reserved |
reserved |
reserved |
reserved |
GO |
non-reserved |
non-reserved |
reserved |
|
GOTO |
non-reserved |
non-reserved |
reserved |
|
GRANT |
reserved, requires AS |
reserved |
reserved |
reserved |
GRANTED |
non-reserved |
non-reserved |
non-reserved |
|
GREATEST |
非保留（不能是函数或类型） |
reserved |
||
GROUP |
reserved, requires AS |
reserved |
reserved |
reserved |
GROUPING |
非保留（不能是函数或类型） |
reserved |
reserved |
|
GROUPS |
non-reserved |
reserved |
reserved |
|
HANDLER |
non-reserved |
|||
HAVING |
reserved, requires AS |
reserved |
reserved |
reserved |
HEADER |
non-reserved |
|||
HEX |
non-reserved |
non-reserved |
||
HIERARCHY |
non-reserved |
non-reserved |
||
HOLD |
non-reserved |
reserved |
reserved |
|
HOUR |
non-reserved, requires AS |
reserved |
reserved |
reserved |
ID |
non-reserved |
non-reserved |
||
IDENTITY |
non-reserved |
reserved |
reserved |
reserved |
IF |
non-reserved |
|||
IGNORE |
non-reserved |
non-reserved |
||
ILIKE |
保留（可以是函数或类型） |
|||
IMMEDIATE |
non-reserved |
non-reserved |
non-reserved |
reserved |
IMMEDIATELY |
non-reserved |
non-reserved |
||
IMMUTABLE |
non-reserved |
|||
IMPLEMENTATION |
non-reserved |
non-reserved |
||
IMPLICIT |
non-reserved |
|||
IMPORT |
non-reserved |
reserved |
reserved |
|
IN |
reserved |
reserved |
reserved |
reserved |
INCLUDE |
non-reserved |
|||
INCLUDING |
non-reserved |
non-reserved |
non-reserved |
|
INCREMENT |
non-reserved |
non-reserved |
non-reserved |
|
INDENT |
non-reserved |
non-reserved |
non-reserved |
|
INDEX |
non-reserved |
|||
INDEXES |
non-reserved |
|||
INDICATOR |
reserved |
reserved |
reserved |
|
INHERIT |
non-reserved |
|||
INHERITS |
non-reserved |
|||
INITIAL |
reserved |
reserved |
||
INITIALLY |
reserved |
non-reserved |
non-reserved |
reserved |
INLINE |
non-reserved |
|||
INNER |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
INOUT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
INPUT |
non-reserved |
non-reserved |
non-reserved |
reserved |
INSENSITIVE |
non-reserved |
reserved |
reserved |
reserved |
INSERT |
non-reserved |
reserved |
reserved |
reserved |
INSTANCE |
non-reserved |
non-reserved |
||
INSTANTIABLE |
non-reserved |
non-reserved |
||
INSTEAD |
non-reserved |
non-reserved |
non-reserved |
|
INT |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
INTEGER |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
INTEGRITY |
non-reserved |
non-reserved |
||
INTERSECT |
reserved, requires AS |
reserved |
reserved |
reserved |
INTERSECTION |
reserved |
reserved |
||
INTERVAL |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
INTO |
reserved, requires AS |
reserved |
reserved |
reserved |
INVOKER |
non-reserved |
non-reserved |
non-reserved |
|
IS |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
ISNULL |
保留（可以是函数或类型），需要 AS |
|||
ISOLATION |
non-reserved |
non-reserved |
non-reserved |
reserved |
JOIN |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
JSON |
non-reserved |
reserved |
||
JSON_ARRAY |
非保留（不能是函数或类型） |
reserved |
reserved |
|
JSON_ARRAYAGG |
非保留（不能是函数或类型） |
reserved |
reserved |
|
JSON_EXISTS |
reserved |
reserved |
||
JSON_OBJECT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
JSON_OBJECTAGG |
非保留（不能是函数或类型） |
reserved |
reserved |
|
JSON_QUERY |
reserved |
reserved |
||
JSON_SCALAR |
reserved |
|||
JSON_SERIALIZE |
reserved |
|||
JSON_TABLE |
reserved |
reserved |
||
JSON_TABLE_PRIMITIVE |
reserved |
reserved |
||
JSON_VALUE |
reserved |
reserved |
||
K |
non-reserved |
non-reserved |
||
KEEP |
non-reserved |
non-reserved |
||
KEY |
non-reserved |
non-reserved |
non-reserved |
reserved |
KEYS |
non-reserved |
non-reserved |
non-reserved |
|
KEY_MEMBER |
non-reserved |
non-reserved |
||
KEY_TYPE |
non-reserved |
non-reserved |
||
LABEL |
non-reserved |
|||
LAG |
reserved |
reserved |
||
LANGUAGE |
non-reserved |
reserved |
reserved |
reserved |
LARGE |
non-reserved |
reserved |
reserved |
|
LAST |
non-reserved |
non-reserved |
non-reserved |
reserved |
LAST_VALUE |
reserved |
reserved |
||
LATERAL |
reserved |
reserved |
reserved |
|
LEAD |
reserved |
reserved |
||
LEADING |
reserved |
reserved |
reserved |
reserved |
LEAKPROOF |
non-reserved |
|||
LEAST |
非保留（不能是函数或类型） |
reserved |
||
LEFT |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
LENGTH |
non-reserved |
non-reserved |
non-reserved |
|
LEVEL |
non-reserved |
non-reserved |
non-reserved |
reserved |
LIBRARY |
non-reserved |
non-reserved |
||
LIKE |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
LIKE_REGEX |
reserved |
reserved |
||
LIMIT |
reserved, requires AS |
non-reserved |
non-reserved |
|
LINK |
non-reserved |
non-reserved |
||
LISTAGG |
reserved |
reserved |
||
LISTEN |
non-reserved |
|||
LN |
reserved |
reserved |
||
LOAD |
non-reserved |
|||
LOCAL |
non-reserved |
reserved |
reserved |
reserved |
LOCALTIME |
reserved |
reserved |
reserved |
|
LOCALTIMESTAMP |
reserved |
reserved |
reserved |
|
LOCATION |
non-reserved |
non-reserved |
non-reserved |
|
LOCATOR |
non-reserved |
non-reserved |
||
LOCK |
non-reserved |
|||
LOCKED |
non-reserved |
|||
LOG |
reserved |
reserved |
||
LOG10 |
reserved |
reserved |
||
LOGGED |
non-reserved |
|||
LOWER |
reserved |
reserved |
reserved |
|
LPAD |
reserved |
|||
LTRIM |
reserved |
|||
M |
non-reserved |
non-reserved |
||
MAP |
non-reserved |
non-reserved |
||
MAPPING |
non-reserved |
non-reserved |
non-reserved |
|
MATCH |
non-reserved |
reserved |
reserved |
reserved |
MATCHED |
non-reserved |
non-reserved |
non-reserved |
|
MATCHES |
reserved |
reserved |
||
MATCH_NUMBER |
reserved |
reserved |
||
MATCH_RECOGNIZE |
reserved |
reserved |
||
MATERIALIZED |
non-reserved |
|||
MAX |
reserved |
reserved |
reserved |
|
MAXVALUE |
non-reserved |
non-reserved |
non-reserved |
|
MEASURES |
non-reserved |
non-reserved |
||
MEMBER |
reserved |
reserved |
||
MERGE |
non-reserved |
reserved |
reserved |
|
MESSAGE_LENGTH |
non-reserved |
non-reserved |
non-reserved |
|
MESSAGE_OCTET_LENGTH |
non-reserved |
non-reserved |
non-reserved |
|
MESSAGE_TEXT |
non-reserved |
non-reserved |
non-reserved |
|
METHOD |
non-reserved |
reserved |
reserved |
|
MIN |
reserved |
reserved |
reserved |
|
MINUTE |
non-reserved, requires AS |
reserved |
reserved |
reserved |
MINVALUE |
non-reserved |
non-reserved |
non-reserved |
|
MOD |
reserved |
reserved |
||
MODE |
non-reserved |
|||
MODIFIES |
reserved |
reserved |
||
MODULE |
reserved |
reserved |
reserved |
|
MONTH |
non-reserved, requires AS |
reserved |
reserved |
reserved |
MORE |
non-reserved |
non-reserved |
non-reserved |
|
MOVE |
non-reserved |
|||
MULTISET |
reserved |
reserved |
||
MUMPS |
non-reserved |
non-reserved |
non-reserved |
|
NAME |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
NAMES |
non-reserved |
non-reserved |
non-reserved |
reserved |
NAMESPACE |
non-reserved |
non-reserved |
||
NATIONAL |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
NATURAL |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
NCHAR |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
NCLOB |
reserved |
reserved |
||
NESTED |
non-reserved |
non-reserved |
||
NESTING |
non-reserved |
non-reserved |
||
NEW |
non-reserved |
reserved |
reserved |
|
NEXT |
non-reserved |
non-reserved |
non-reserved |
reserved |
NFC |
non-reserved |
non-reserved |
non-reserved |
|
NFD |
non-reserved |
non-reserved |
non-reserved |
|
NFKC |
non-reserved |
non-reserved |
non-reserved |
|
NFKD |
non-reserved |
non-reserved |
non-reserved |
|
NIL |
non-reserved |
non-reserved |
||
NO |
non-reserved |
reserved |
reserved |
reserved |
NONE |
非保留（不能是函数或类型） |
reserved |
reserved |
|
NORMALIZE |
非保留（不能是函数或类型） |
reserved |
reserved |
|
NORMALIZED |
non-reserved |
non-reserved |
non-reserved |
|
NOT |
reserved |
reserved |
reserved |
reserved |
NOTHING |
non-reserved |
|||
NOTIFY |
non-reserved |
|||
NOTNULL |
保留（可以是函数或类型），需要 AS |
|||
NOWAIT |
non-reserved |
|||
NTH_VALUE |
reserved |
reserved |
||
NTILE |
reserved |
reserved |
||
NULL |
reserved |
reserved |
reserved |
reserved |
NULLABLE |
non-reserved |
non-reserved |
non-reserved |
|
NULLIF |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
NULLS |
non-reserved |
non-reserved |
non-reserved |
|
NULL_ORDERING |
non-reserved |
non-reserved |
||
NUMBER |
non-reserved |
non-reserved |
non-reserved |
|
NUMERIC |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
OBJECT |
non-reserved |
non-reserved |
non-reserved |
|
OCCURRENCE |
non-reserved |
non-reserved |
||
OCCURRENCES_REGEX |
reserved |
reserved |
||
OCTETS |
non-reserved |
non-reserved |
||
OCTET_LENGTH |
reserved |
reserved |
reserved |
|
OF |
non-reserved |
reserved |
reserved |
reserved |
OFF |
non-reserved |
non-reserved |
non-reserved |
|
OFFSET |
reserved, requires AS |
reserved |
reserved |
|
OIDS |
non-reserved |
|||
OLD |
non-reserved |
reserved |
reserved |
|
OMIT |
reserved |
reserved |
||
ON |
reserved, requires AS |
reserved |
reserved |
reserved |
ONE |
reserved |
reserved |
||
ONLY |
reserved |
reserved |
reserved |
reserved |
OPEN |
reserved |
reserved |
reserved |
|
OPERATOR |
non-reserved |
|||
OPTION |
non-reserved |
non-reserved |
non-reserved |
reserved |
OPTIONS |
non-reserved |
non-reserved |
non-reserved |
|
OR |
reserved |
reserved |
reserved |
reserved |
ORDER |
reserved, requires AS |
reserved |
reserved |
reserved |
ORDERING |
non-reserved |
non-reserved |
||
ORDINALITY |
non-reserved |
non-reserved |
non-reserved |
|
OTHERS |
non-reserved |
non-reserved |
non-reserved |
|
OUT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
OUTER |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
OUTPUT |
non-reserved |
non-reserved |
reserved |
|
OVER |
non-reserved, requires AS |
reserved |
reserved |
|
OVERFLOW |
non-reserved |
non-reserved |
||
OVERLAPS |
保留（可以是函数或类型），需要 AS |
reserved |
reserved |
reserved |
OVERLAY |
非保留（不能是函数或类型） |
reserved |
reserved |
|
OVERRIDING |
non-reserved |
non-reserved |
non-reserved |
|
OWNED |
non-reserved |
|||
OWNER |
non-reserved |
|||
P |
non-reserved |
non-reserved |
||
PAD |
non-reserved |
non-reserved |
reserved |
|
PARALLEL |
non-reserved |
|||
PARAMETER |
non-reserved |
reserved |
reserved |
|
PARAMETER_MODE |
non-reserved |
non-reserved |
||
PARAMETER_NAME |
non-reserved |
non-reserved |
||
PARAMETERORDINAL_POSITION_ |
non-reserved |
non-reserved |
||
PARAMETERSPECIFIC_CATALOG_ |
non-reserved |
non-reserved |
||
PARAMETERSPECIFIC_NAME_ |
non-reserved |
non-reserved |
||
PARAMETERSPECIFIC_SCHEMA_ |
non-reserved |
non-reserved |
||
PARSER |
non-reserved |
|||
PARTIAL |
non-reserved |
non-reserved |
non-reserved |
reserved |
PARTITION |
non-reserved |
reserved |
reserved |
|
PASCAL |
non-reserved |
non-reserved |
non-reserved |
|
PASS |
non-reserved |
non-reserved |
||
PASSING |
non-reserved |
non-reserved |
non-reserved |
|
PASSTHROUGH |
non-reserved |
non-reserved |
||
PASSWORD |
non-reserved |
|||
PAST |
non-reserved |
non-reserved |
||
PATH |
non-reserved |
non-reserved |
||
PATTERN |
reserved |
reserved |
||
PER |
reserved |
reserved |
||
PERCENT |
reserved |
reserved |
||
PERCENTILE_CONT |
reserved |
reserved |
||
PERCENTILE_DISC |
reserved |
reserved |
||
PERCENT_RANK |
reserved |
reserved |
||
PERIOD |
reserved |
reserved |
||
PERMISSION |
non-reserved |
non-reserved |
||
PERMUTE |
non-reserved |
non-reserved |
||
PIPE |
non-reserved |
non-reserved |
||
PLACING |
reserved |
non-reserved |
non-reserved |
|
PLAN |
non-reserved |
non-reserved |
||
PLANS |
non-reserved |
|||
PLI |
non-reserved |
non-reserved |
non-reserved |
|
POLICY |
non-reserved |
|||
PORTION |
reserved |
reserved |
||
POSITION |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
POSITION_REGEX |
reserved |
reserved |
||
POWER |
reserved |
reserved |
||
PRECEDES |
reserved |
reserved |
||
PRECEDING |
non-reserved |
non-reserved |
non-reserved |
|
PRECISION |
非保留（不能是函数或类型），需要 AS |
reserved |
reserved |
reserved |
PREPARE |
non-reserved |
reserved |
reserved |
reserved |
PREPARED |
non-reserved |
|||
PRESERVE |
non-reserved |
non-reserved |
non-reserved |
reserved |
PREV |
non-reserved |
non-reserved |
||
PRIMARY |
reserved |
reserved |
reserved |
reserved |
PRIOR |
non-reserved |
non-reserved |
non-reserved |
reserved |
PRIVATE |
non-reserved |
non-reserved |
||
PRIVILEGES |
non-reserved |
non-reserved |
non-reserved |
reserved |
PROCEDURAL |
non-reserved |
|||
PROCEDURE |
non-reserved |
reserved |
reserved |
reserved |
PROCEDURES |
non-reserved |
|||
PROGRAM |
non-reserved |
|||
PRUNE |
non-reserved |
non-reserved |
||
PTF |
reserved |
reserved |
||
PUBLIC |
non-reserved |
non-reserved |
reserved |
|
PUBLICATION |
non-reserved |
|||
QUOTE |
non-reserved |
|||
QUOTES |
non-reserved |
non-reserved |
||
RANGE |
non-reserved |
reserved |
reserved |
|
RANK |
reserved |
reserved |
||
READ |
non-reserved |
non-reserved |
non-reserved |
reserved |
READS |
reserved |
reserved |
||
REAL |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
REASSIGN |
non-reserved |
|||
RECHECK |
non-reserved |
|||
RECOVERY |
non-reserved |
non-reserved |
||
RECURSIVE |
non-reserved |
reserved |
reserved |
|
REF |
non-reserved |
reserved |
reserved |
|
REFERENCES |
reserved |
reserved |
reserved |
reserved |
REFERENCING |
non-reserved |
reserved |
reserved |
|
REFRESH |
non-reserved |
|||
REGR_AVGX |
reserved |
reserved |
||
REGR_AVGY |
reserved |
reserved |
||
REGR_COUNT |
reserved |
reserved |
||
REGR_INTERCEPT |
reserved |
reserved |
||
REGR_R2 |
reserved |
reserved |
||
REGR_SLOPE |
reserved |
reserved |
||
REGR_SXX |
reserved |
reserved |
||
REGR_SXY |
reserved |
reserved |
||
REGR_SYY |
reserved |
reserved |
||
REINDEX |
non-reserved |
|||
RELATIVE |
non-reserved |
non-reserved |
non-reserved |
reserved |
RELEASE |
non-reserved |
reserved |
reserved |
|
RENAME |
non-reserved |
|||
REPEATABLE |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
REPLACE |
non-reserved |
|||
REPLICA |
non-reserved |
|||
REQUIRING |
non-reserved |
non-reserved |
||
RESET |
non-reserved |
|||
RESPECT |
non-reserved |
non-reserved |
||
RESTART |
non-reserved |
non-reserved |
non-reserved |
|
RESTORE |
non-reserved |
non-reserved |
||
RESTRICT |
non-reserved |
non-reserved |
non-reserved |
reserved |
RESULT |
reserved |
reserved |
||
RETURN |
non-reserved |
reserved |
reserved |
|
RETURNED_CARDINALITY |
non-reserved |
non-reserved |
||
RETURNED_LENGTH |
non-reserved |
non-reserved |
non-reserved |
|
RETURNEDOCTET_LENGTH_ |
non-reserved |
non-reserved |
non-reserved |
|
RETURNED_SQLSTATE |
non-reserved |
non-reserved |
non-reserved |
|
RETURNING |
reserved, requires AS |
non-reserved |
non-reserved |
|
RETURNS |
non-reserved |
reserved |
reserved |
|
REVOKE |
non-reserved |
reserved |
reserved |
reserved |
RIGHT |
保留（可以是函数或类型） |
reserved |
reserved |
reserved |
ROLE |
non-reserved |
non-reserved |
non-reserved |
|
ROLLBACK |
non-reserved |
reserved |
reserved |
reserved |
ROLLUP |
non-reserved |
reserved |
reserved |
|
ROUTINE |
non-reserved |
non-reserved |
non-reserved |
|
ROUTINES |
non-reserved |
|||
ROUTINE_CATALOG |
non-reserved |
non-reserved |
||
ROUTINE_NAME |
non-reserved |
non-reserved |
||
ROUTINE_SCHEMA |
non-reserved |
non-reserved |
||
ROW |
非保留（不能是函数或类型） |
reserved |
reserved |
|
ROWS |
non-reserved |
reserved |
reserved |
reserved |
ROW_COUNT |
non-reserved |
non-reserved |
non-reserved |
|
ROW_NUMBER |
reserved |
reserved |
||
RPAD |
reserved |
|||
RTRIM |
reserved |
|||
RULE |
non-reserved |
|||
RUNNING |
reserved |
reserved |
||
SAVEPOINT |
non-reserved |
reserved |
reserved |
|
SCALAR |
non-reserved |
non-reserved |
non-reserved |
|
SCALE |
non-reserved |
non-reserved |
non-reserved |
|
SCHEMA |
non-reserved |
non-reserved |
non-reserved |
reserved |
SCHEMAS |
non-reserved |
|||
SCHEMA_NAME |
non-reserved |
non-reserved |
non-reserved |
|
SCOPE |
reserved |
reserved |
||
SCOPE_CATALOG |
non-reserved |
non-reserved |
||
SCOPE_NAME |
non-reserved |
non-reserved |
||
SCOPE_SCHEMA |
non-reserved |
non-reserved |
||
SCROLL |
non-reserved |
reserved |
reserved |
reserved |
SEARCH |
non-reserved |
reserved |
reserved |
|
SECOND |
non-reserved, requires AS |
reserved |
reserved |
reserved |
SECTION |
non-reserved |
non-reserved |
reserved |
|
SECURITY |
non-reserved |
non-reserved |
non-reserved |
|
SEEK |
reserved |
reserved |
||
SELECT |
reserved |
reserved |
reserved |
reserved |
SELECTIVE |
non-reserved |
non-reserved |
||
SELF |
non-reserved |
non-reserved |
||
SEMANTICS |
non-reserved |
non-reserved |
||
SENSITIVE |
reserved |
reserved |
||
SEQUENCE |
non-reserved |
non-reserved |
non-reserved |
|
SEQUENCES |
non-reserved |
|||
SERIALIZABLE |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
SERVER |
non-reserved |
non-reserved |
non-reserved |
|
SERVER_NAME |
non-reserved |
non-reserved |
non-reserved |
|
SESSION |
non-reserved |
non-reserved |
non-reserved |
reserved |
SESSION_USER |
reserved |
reserved |
reserved |
reserved |
SET |
non-reserved |
reserved |
reserved |
reserved |
SETOF |
非保留（不能是函数或类型） |
|||
SETS |
non-reserved |
non-reserved |
non-reserved |
|
SHARE |
non-reserved |
|||
SHOW |
non-reserved |
reserved |
reserved |
|
SIMILAR |
保留（可以是函数或类型） |
reserved |
reserved |
|
SIMPLE |
non-reserved |
non-reserved |
non-reserved |
|
SIN |
reserved |
reserved |
||
SINH |
reserved |
reserved |
||
SIZE |
non-reserved |
non-reserved |
reserved |
|
SKIP |
non-reserved |
reserved |
reserved |
|
SMALLINT |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
SNAPSHOT |
non-reserved |
|||
SOME |
reserved |
reserved |
reserved |
reserved |
SORT_DIRECTION |
non-reserved |
non-reserved |
||
SOURCE |
non-reserved |
non-reserved |
||
SPACE |
non-reserved |
non-reserved |
reserved |
|
SPECIFIC |
reserved |
reserved |
||
SPECIFICTYPE |
reserved |
reserved |
||
SPECIFIC_NAME |
non-reserved |
non-reserved |
||
SQL |
non-reserved |
reserved |
reserved |
reserved |
SQLCODE |
reserved |
|||
SQLERROR |
reserved |
|||
SQLEXCEPTION |
reserved |
reserved |
||
SQLSTATE |
reserved |
reserved |
reserved |
|
SQLWARNING |
reserved |
reserved |
||
SQRT |
reserved |
reserved |
||
STABLE |
non-reserved |
|||
STANDALONE |
non-reserved |
non-reserved |
non-reserved |
|
START |
non-reserved |
reserved |
reserved |
|
STATE |
non-reserved |
non-reserved |
||
STATEMENT |
non-reserved |
non-reserved |
non-reserved |
|
STATIC |
reserved |
reserved |
||
STATISTICS |
non-reserved |
|||
STDDEV_POP |
reserved |
reserved |
||
STDDEV_SAMP |
reserved |
reserved |
||
STDIN |
non-reserved |
|||
STDOUT |
non-reserved |
|||
STORAGE |
non-reserved |
|||
STORED |
non-reserved |
|||
STRICT |
non-reserved |
|||
STRING |
non-reserved |
non-reserved |
||
STRIP |
non-reserved |
non-reserved |
non-reserved |
|
STRUCTURE |
non-reserved |
non-reserved |
||
STYLE |
non-reserved |
non-reserved |
||
SUBCLASS_ORIGIN |
non-reserved |
non-reserved |
non-reserved |
|
SUBMULTISET |
reserved |
reserved |
||
SUBSCRIPTION |
non-reserved |
|||
SUBSET |
reserved |
reserved |
||
SUBSTRING |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
SUBSTRING_REGEX |
reserved |
reserved |
||
SUCCEEDS |
reserved |
reserved |
||
SUM |
reserved |
reserved |
reserved |
|
SUPPORT |
non-reserved |
|||
SYMMETRIC |
reserved |
reserved |
reserved |
|
SYSID |
non-reserved |
|||
SYSTEM |
non-reserved |
reserved |
reserved |
|
SYSTEM_TIME |
reserved |
reserved |
||
SYSTEM_USER |
reserved |
reserved |
reserved |
reserved |
T |
non-reserved |
non-reserved |
||
TABLE |
reserved |
reserved |
reserved |
reserved |
TABLES |
non-reserved |
|||
TABLESAMPLE |
保留（可以是函数或类型） |
reserved |
reserved |
|
TABLESPACE |
non-reserved |
|||
TABLE_NAME |
non-reserved |
non-reserved |
non-reserved |
|
TAN |
reserved |
reserved |
||
TANH |
reserved |
reserved |
||
TEMP |
non-reserved |
|||
TEMPLATE |
non-reserved |
|||
TEMPORARY |
non-reserved |
non-reserved |
non-reserved |
reserved |
TEXT |
non-reserved |
|||
THEN |
reserved |
reserved |
reserved |
reserved |
THROUGH |
non-reserved |
non-reserved |
||
TIES |
non-reserved |
non-reserved |
non-reserved |
|
TIME |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
TIMESTAMP |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
TIMEZONE_HOUR |
reserved |
reserved |
reserved |
|
TIMEZONE_MINUTE |
reserved |
reserved |
reserved |
|
TO |
reserved, requires AS |
reserved |
reserved |
reserved |
TOKEN |
non-reserved |
non-reserved |
||
TOP_LEVEL_COUNT |
non-reserved |
non-reserved |
||
TRAILING |
reserved |
reserved |
reserved |
reserved |
TRANSACTION |
non-reserved |
non-reserved |
non-reserved |
reserved |
TRANSACTIONSCOMMITTED_ |
non-reserved |
non-reserved |
||
TRANSACTIONSROLLED_BACK_ |
non-reserved |
non-reserved |
||
TRANSACTION_ACTIVE |
non-reserved |
non-reserved |
||
TRANSFORM |
non-reserved |
non-reserved |
non-reserved |
|
TRANSFORMS |
non-reserved |
non-reserved |
||
TRANSLATE |
reserved |
reserved |
reserved |
|
TRANSLATE_REGEX |
reserved |
reserved |
||
TRANSLATION |
reserved |
reserved |
reserved |
|
TREAT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
TRIGGER |
non-reserved |
reserved |
reserved |
|
TRIGGER_CATALOG |
non-reserved |
non-reserved |
||
TRIGGER_NAME |
non-reserved |
non-reserved |
||
TRIGGER_SCHEMA |
non-reserved |
non-reserved |
||
TRIM |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
TRIM_ARRAY |
reserved |
reserved |
||
TRUE |
reserved |
reserved |
reserved |
reserved |
TRUNCATE |
non-reserved |
reserved |
reserved |
|
TRUSTED |
non-reserved |
|||
TYPE |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
TYPES |
non-reserved |
|||
UESCAPE |
non-reserved |
reserved |
reserved |
|
UNBOUNDED |
non-reserved |
non-reserved |
non-reserved |
|
UNCOMMITTED |
non-reserved |
non-reserved |
non-reserved |
non-reserved |
UNCONDITIONAL |
non-reserved |
non-reserved |
||
UNDER |
non-reserved |
non-reserved |
||
UNENCRYPTED |
non-reserved |
|||
UNION |
reserved, requires AS |
reserved |
reserved |
reserved |
UNIQUE |
reserved |
reserved |
reserved |
reserved |
UNKNOWN |
non-reserved |
reserved |
reserved |
reserved |
UNLINK |
non-reserved |
non-reserved |
||
UNLISTEN |
non-reserved |
|||
UNLOGGED |
non-reserved |
|||
UNMATCHED |
non-reserved |
non-reserved |
||
UNNAMED |
non-reserved |
non-reserved |
non-reserved |
|
UNNEST |
reserved |
reserved |
||
UNTIL |
non-reserved |
|||
UNTYPED |
non-reserved |
non-reserved |
||
UPDATE |
non-reserved |
reserved |
reserved |
reserved |
UPPER |
reserved |
reserved |
reserved |
|
URI |
non-reserved |
non-reserved |
||
USAGE |
non-reserved |
non-reserved |
reserved |
|
USER |
reserved |
reserved |
reserved |
reserved |
USERDEFINED_TYPE_CATALOG_ |
non-reserved |
non-reserved |
||
USERDEFINED_TYPE_CODE_ |
non-reserved |
non-reserved |
||
USERDEFINED_TYPE_NAME_ |
non-reserved |
non-reserved |
||
USERDEFINED_TYPE_SCHEMA_ |
non-reserved |
non-reserved |
||
USING |
reserved |
reserved |
reserved |
reserved |
UTF16 |
non-reserved |
non-reserved |
||
UTF32 |
non-reserved |
non-reserved |
||
UTF8 |
non-reserved |
non-reserved |
||
VACUUM |
non-reserved |
|||
VALID |
non-reserved |
non-reserved |
non-reserved |
|
VALIDATE |
non-reserved |
|||
VALIDATOR |
non-reserved |
|||
VALUE |
non-reserved |
reserved |
reserved |
reserved |
VALUES |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
VALUE_OF |
reserved |
reserved |
||
VARBINARY |
reserved |
reserved |
||
VARCHAR |
非保留（不能是函数或类型） |
reserved |
reserved |
reserved |
VARIADIC |
reserved |
|||
VARYING |
non-reserved, requires AS |
reserved |
reserved |
reserved |
VAR_POP |
reserved |
reserved |
||
VAR_SAMP |
reserved |
reserved |
||
VERBOSE |
保留（可以是函数或类型） |
|||
VERSION |
non-reserved |
non-reserved |
non-reserved |
|
VERSIONING |
reserved |
reserved |
||
VIEW |
non-reserved |
non-reserved |
non-reserved |
reserved |
VIEWS |
non-reserved |
|||
VOLATILE |
non-reserved |
|||
WHEN |
reserved |
reserved |
reserved |
reserved |
WHENEVER |
reserved |
reserved |
reserved |
|
WHERE |
reserved, requires AS |
reserved |
reserved |
reserved |
WHITESPACE |
non-reserved |
non-reserved |
non-reserved |
|
WIDTH_BUCKET |
reserved |
reserved |
||
WINDOW |
reserved, requires AS |
reserved |
reserved |
|
WITH |
reserved, requires AS |
reserved |
reserved |
reserved |
WITHIN |
non-reserved, requires AS |
reserved |
reserved |
|
WITHOUT |
non-reserved, requires AS |
reserved |
reserved |
|
WORK |
non-reserved |
non-reserved |
non-reserved |
reserved |
WRAPPER |
non-reserved |
non-reserved |
non-reserved |
|
WRITE |
non-reserved |
non-reserved |
non-reserved |
reserved |
XML |
non-reserved |
reserved |
reserved |
|
XMLAGG |
reserved |
reserved |
||
XMLATTRIBUTES |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLBINARY |
reserved |
reserved |
||
XMLCAST |
reserved |
reserved |
||
XMLCOMMENT |
reserved |
reserved |
||
XMLCONCAT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLDECLARATION |
non-reserved |
non-reserved |
||
XMLDOCUMENT |
reserved |
reserved |
||
XMLELEMENT |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLEXISTS |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLFOREST |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLITERATE |
reserved |
reserved |
||
XMLNAMESPACES |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLPARSE |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLPI |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLQUERY |
reserved |
reserved |
||
XMLROOT |
非保留（不能是函数或类型） |
|||
XMLSCHEMA |
non-reserved |
non-reserved |
||
XMLSERIALIZE |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLTABLE |
非保留（不能是函数或类型） |
reserved |
reserved |
|
XMLTEXT |
reserved |
reserved |
||
XMLVALIDATE |
reserved |
reserved |
||
YEAR |
non-reserved, requires AS |
reserved |
reserved |
reserved |
YES |
non-reserved |
non-reserved |
non-reserved |
|
ZONE |
non-reserved |
non-reserved |
non-reserved |
reserved |