PostgreSQL 13.1 中文入门教程 PostgreSQL SQL关键词

2024-02-25 开发教程 PostgreSQL 13.1 中文入门教程 匿名 0

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

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

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

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

作为一条一般性的规则,如果对包含所列出关键词作为标识符的命令得到了站不住脚的解析器错误,应该尝试将该标识符加上引号来看看是否能解决问题。

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

表 C.1. SQL Key Words

Key Word

PostgreSQL

SQL:2016SQL:2011SQL-92

A

non-reservednon-reserved

ABORT

non-reserved

ABS

reservedreserved

ABSENT

non-reservednon-reserved

ABSOLUTE

non-reservednon-reservednon-reservedreserved

ACCESS

non-reserved

ACCORDING

non-reservednon-reserved

ACOS

reserved

ACTION

non-reservednon-reservednon-reservedreserved

ADA

non-reservednon-reservednon-reserved

ADD

non-reservednon-reservednon-reservedreserved

ADMIN

non-reservednon-reservednon-reserved

AFTER

non-reservednon-reservednon-reserved

AGGREGATE

non-reserved

ALL

reservedreservedreservedreserved

ALLOCATE

reservedreservedreserved

ALSO

non-reserved

ALTER

non-reservedreservedreservedreserved

ALWAYS

non-reservednon-reservednon-reserved

ANALYSE

reserved

ANALYZE

reserved

AND

reservedreservedreservedreserved

ANY

reservedreservedreservedreserved

ARE

reservedreservedreserved

ARRAY

reservedreservedreserved

ARRAY_AGG

reservedreserved

ARRAY_​MAX_​CARDINALITY

reservedreserved

AS

reservedreservedreservedreserved

ASC

reservednon-reservednon-reservedreserved

ASENSITIVE

reservedreserved

ASIN

reserved

ASSERTION

non-reservednon-reservednon-reservedreserved

ASSIGNMENT

non-reservednon-reservednon-reserved

ASYMMETRIC

reservedreservedreserved

AT

non-reservedreservedreservedreserved

ATAN

reserved

ATOMIC

reservedreserved

ATTACH

non-reserved

ATTRIBUTE

non-reservednon-reservednon-reserved

ATTRIBUTES

non-reservednon-reserved

AUTHORIZATION

reserved (can be function or type)reservedreservedreserved

AVG

reservedreservedreserved

BACKWARD

non-reserved

BASE64

non-reservednon-reserved

BEFORE

non-reservednon-reservednon-reserved

BEGIN

non-reservedreservedreservedreserved

BEGIN_FRAME

reservedreserved

BEGIN_PARTITION

reservedreserved

BERNOULLI

non-reservednon-reserved

BETWEEN

non-reserved (cannot be function or type)reservedreservedreserved

BIGINT

non-reserved (cannot be function or type)reservedreserved

BINARY

reserved (can be function or type)reservedreserved

BIT

non-reserved (cannot be function or type)reserved

BIT_LENGTH

reserved

BLOB

reservedreserved

BLOCKED

non-reservednon-reserved

BOM

non-reservednon-reserved

BOOLEAN

non-reserved (cannot be function or type)reservedreserved

BOTH

reservedreservedreservedreserved

BREADTH

non-reservednon-reserved

BY

non-reservedreservedreservedreserved

C

non-reservednon-reservednon-reserved

CACHE

non-reserved

CALL

non-reservedreservedreserved

CALLED

non-reservedreservedreserved

CARDINALITY

reservedreserved

CASCADE

non-reservednon-reservednon-reservedreserved

CASCADED

non-reservedreservedreservedreserved

CASE

reservedreservedreservedreserved

CAST

reservedreservedreservedreserved

CATALOG

non-reservednon-reservednon-reservedreserved

CATALOG_NAME

non-reservednon-reservednon-reserved

CEIL

reservedreserved

CEILING

reservedreserved

CHAIN

non-reservednon-reservednon-reserved

CHAINING

non-reserved

CHAR

non-reserved (cannot be function or type)reservedreservedreserved

CHARACTER

non-reserved (cannot be function or type)reservedreservedreserved

CHARACTERISTICS

non-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

CHECK

reservedreservedreservedreserved

CHECKPOINT

non-reserved

CLASS

non-reserved

CLASSIFIER

reserved

CLASS_ORIGIN

non-reservednon-reservednon-reserved

CLOB

reservedreserved

CLOSE

non-reservedreservedreservedreserved

CLUSTER

non-reserved

COALESCE

non-reserved (cannot be function or type)reservedreservedreserved

COBOL

non-reservednon-reservednon-reserved

COLLATE

reservedreservedreservedreserved

COLLATION

reserved (can be function or type)non-reservednon-reservedreserved

COLLATION_CATALOG

non-reservednon-reservednon-reserved

COLLATION_NAME

non-reservednon-reservednon-reserved

COLLATION_SCHEMA

non-reservednon-reservednon-reserved

COLLECT

reservedreserved

COLUMN

reservedreservedreservedreserved

COLUMNS

non-reservednon-reservednon-reserved

COLUMN_NAME

non-reservednon-reservednon-reserved

COMMAND_FUNCTION

non-reservednon-reservednon-reserved

COMMAND_​FUNCTION_​CODE

non-reservednon-reserved

COMMENT

non-reserved

COMMENTS

non-reserved

COMMIT

non-reservedreservedreservedreserved

COMMITTED

non-reservednon-reservednon-reservednon-reserved

CONCURRENTLY

reserved (can be function or type)

CONDITION

reservedreserved

CONDITIONAL

non-reserved

CONDITION_NUMBER

non-reservednon-reservednon-reserved

CONFIGURATION

non-reserved

CONFLICT

non-reserved

CONNECT

reservedreservedreserved

CONNECTION

non-reservednon-reservednon-reservedreserved

CONNECTION_NAME

non-reservednon-reservednon-reserved

CONSTRAINT

reservedreservedreservedreserved

CONSTRAINTS

non-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

reservedreserved

CONTENT

non-reservednon-reservednon-reserved

CONTINUE

non-reservednon-reservednon-reservedreserved

CONTROL

non-reservednon-reserved

CONVERSION

non-reserved

CONVERT

reservedreservedreserved

COPY

non-reservedreserved

CORR

reservedreserved

CORRESPONDING

reservedreservedreserved

COS

reserved

COSH

reserved

COST

non-reserved

COUNT

reservedreservedreserved

COVAR_POP

reservedreserved

COVAR_SAMP

reservedreserved

CREATE

reservedreservedreservedreserved

CROSS

reserved (can be function or type)reservedreservedreserved

CSV

non-reserved

CUBE

non-reservedreservedreserved

CUME_DIST

reservedreserved

CURRENT

non-reservedreservedreservedreserved

CURRENT_CATALOG

reservedreservedreserved

CURRENT_DATE

reservedreservedreservedreserved

CURRENT_​DEFAULT_​TRANSFORM_​GROUP

reservedreserved

CURRENT_PATH

reservedreserved

CURRENT_ROLE

reservedreservedreserved

CURRENT_ROW

reservedreserved

CURRENT_SCHEMA

reserved (can be function or type)reservedreserved

CURRENT_TIME

reservedreservedreservedreserved

CURRENT_TIMESTAMP

reservedreservedreservedreserved

CURRENT_​TRANSFORM_​GROUP_​FOR_​TYPE

reservedreserved

CURRENT_USER

reservedreservedreservedreserved

CURSOR

non-reservedreservedreservedreserved

CURSOR_NAME

non-reservednon-reservednon-reserved

CYCLE

non-reservedreservedreserved

DATA

non-reservednon-reservednon-reservednon-reserved

DATABASE

non-reserved

DATALINK

reservedreserved

DATE

reservedreservedreserved

DATETIME_​INTERVAL_​CODE

non-reservednon-reservednon-reserved

DATETIME_​INTERVAL_​PRECISION

non-reservednon-reservednon-reserved

DAY

non-reservedreservedreservedreserved

DB

non-reservednon-reserved

DEALLOCATE

non-reservedreservedreservedreserved

DEC

non-reserved (cannot be function or type)reservedreservedreserved

DECFLOAT

reserved

DECIMAL

non-reserved (cannot be function or type)reservedreservedreserved

DECLARE

non-reservedreservedreservedreserved

DEFAULT

reservedreservedreservedreserved

DEFAULTS

non-reservednon-reservednon-reserved

DEFERRABLE

reservednon-reservednon-reservedreserved

DEFERRED

non-reservednon-reservednon-reservedreserved

DEFINE

reserved

DEFINED

non-reservednon-reserved

DEFINER

non-reservednon-reservednon-reserved

DEGREE

non-reservednon-reserved

DELETE

non-reservedreservedreservedreserved

DELIMITER

non-reserved

DELIMITERS

non-reserved

DENSE_RANK

reservedreserved

DEPENDS

non-reserved

DEPTH

non-reservednon-reserved

DEREF

reservedreserved

DERIVED

non-reservednon-reserved

DESC

reservednon-reservednon-reservedreserved

DESCRIBE

reservedreservedreserved

DESCRIPTOR

non-reservednon-reservedreserved

DETACH

non-reserved

DETERMINISTIC

reservedreserved

DIAGNOSTICS

non-reservednon-reservedreserved

DICTIONARY

non-reserved

DISABLE

non-reserved

DISCARD

non-reserved

DISCONNECT

reservedreservedreserved

DISPATCH

non-reservednon-reserved

DISTINCT

reservedreservedreservedreserved

DLNEWCOPY

reservedreserved

DLPREVIOUSCOPY

reservedreserved

DLURLCOMPLETE

reservedreserved

DLURLCOMPLETEONLY

reservedreserved

DLURLCOMPLETEWRITE

reservedreserved

DLURLPATH

reservedreserved

DLURLPATHONLY

reservedreserved

DLURLPATHWRITE

reservedreserved

DLURLSCHEME

reservedreserved

DLURLSERVER

reservedreserved

DLVALUE

reservedreserved

DO

reserved

DOCUMENT

non-reservednon-reservednon-reserved

DOMAIN

non-reservednon-reservednon-reservedreserved

DOUBLE

non-reservedreservedreservedreserved

DROP

non-reservedreservedreservedreserved

DYNAMIC

reservedreserved

DYNAMIC_FUNCTION

non-reservednon-reservednon-reserved

DYNAMIC_​FUNCTION_​CODE

non-reservednon-reserved

EACH

non-reservedreservedreserved

ELEMENT

reservedreserved

ELSE

reservedreservedreservedreserved

EMPTY

reservednon-reserved

ENABLE

non-reserved

ENCODING

non-reservednon-reservednon-reserved

ENCRYPTED

non-reserved

END

reservedreservedreservedreserved

END-EXEC

reservedreservedreserved

END_FRAME

reservedreserved

END_PARTITION

reservedreserved

ENFORCED

non-reservednon-reserved

ENUM

non-reserved

EQUALS

reservedreserved

ERROR

non-reserved

ESCAPE

non-reservedreservedreservedreserved

EVENT

non-reserved

EVERY

reservedreserved

EXCEPT

reservedreservedreservedreserved

EXCEPTION

reserved

EXCLUDE

non-reservednon-reservednon-reserved

EXCLUDING

non-reservednon-reservednon-reserved

EXCLUSIVE

non-reserved

EXEC

reservedreservedreserved

EXECUTE

non-reservedreservedreservedreserved

EXISTS

non-reserved (cannot be function or type)reservedreservedreserved

EXP

reservedreserved

EXPLAIN

non-reserved

EXPRESSION

non-reservednon-reservednon-reserved

EXTENSION

non-reserved

EXTERNAL

non-reservedreservedreservedreserved

EXTRACT

non-reserved (cannot be function or type)reservedreservedreserved

FALSE

reservedreservedreservedreserved

FAMILY

non-reserved

FETCH

reservedreservedreservedreserved

FILE

non-reservednon-reserved

FILTER

non-reservedreservedreserved

FINAL

non-reservednon-reserved

FINISH

non-reserved

FIRST

non-reservednon-reservednon-reservedreserved

FIRST_VALUE

reservedreserved

FLAG

non-reservednon-reserved

FLOAT

non-reserved (cannot be function or type)reservedreservedreserved

FLOOR

reservedreserved

FOLLOWING

non-reservednon-reservednon-reserved

FOR

reservedreservedreservedreserved

FORCE

non-reserved

FOREIGN

reservedreservedreservedreserved

FORMAT

non-reserved

FORTRAN

non-reservednon-reservednon-reserved

FORWARD

non-reserved

FOUND

non-reservednon-reservedreserved

FRAME_ROW

reservedreserved

FREE

reservedreserved

FREEZE

reserved (can be function or type)

FROM

reservedreservedreservedreserved

FS

non-reservednon-reserved

FULFILL

non-reserved

FULL

reserved (can be function or type)reservedreservedreserved

FUNCTION

non-reservedreservedreserved

FUNCTIONS

non-reserved

FUSION

reservedreserved

G

non-reservednon-reserved

GENERAL

non-reservednon-reserved

GENERATED

non-reservednon-reservednon-reserved

GET

reservedreservedreserved

GLOBAL

non-reservedreservedreservedreserved

GO

non-reservednon-reservedreserved

GOTO

non-reservednon-reservedreserved

GRANT

reservedreservedreservedreserved

GRANTED

non-reservednon-reservednon-reserved

GREATEST

non-reserved (cannot be function or type)

GROUP

reservedreservedreservedreserved

GROUPING

non-reserved (cannot be function or type)reservedreserved

GROUPS

non-reservedreservedreserved

HANDLER

non-reserved

HAVING

reservedreservedreservedreserved

HEADER

non-reserved

HEX

non-reservednon-reserved

HIERARCHY

non-reservednon-reserved

HOLD

non-reservedreservedreserved

HOUR

non-reservedreservedreservedreserved

ID

non-reservednon-reserved

IDENTITY

non-reservedreservedreservedreserved

IF

non-reserved

IGNORE

non-reservednon-reserved

ILIKE

reserved (can be function or type)

IMMEDIATE

non-reservednon-reservednon-reservedreserved

IMMEDIATELY

non-reservednon-reserved

IMMUTABLE

non-reserved

IMPLEMENTATION

non-reservednon-reserved

IMPLICIT

non-reserved

IMPORT

non-reservedreservedreserved

IN

reservedreservedreservedreserved

INCLUDE

non-reserved

INCLUDING

non-reservednon-reservednon-reserved

INCREMENT

non-reservednon-reservednon-reserved

INDENT

non-reservednon-reserved

INDEX

non-reserved

INDEXES

non-reserved

INDICATOR

reservedreservedreserved

INHERIT

non-reserved

INHERITS

non-reserved

INITIAL

reserved

INITIALLY

reservednon-reservednon-reservedreserved

INLINE

non-reserved

INNER

reserved (can be function or type)reservedreservedreserved

INOUT

non-reserved (cannot be function or type)reservedreserved

INPUT

non-reservednon-reservednon-reservedreserved

INSENSITIVE

non-reservedreservedreservedreserved

INSERT

non-reservedreservedreservedreserved

INSTANCE

non-reservednon-reserved

INSTANTIABLE

non-reservednon-reserved

INSTEAD

non-reservednon-reservednon-reserved

INT

non-reserved (cannot be function or type)reservedreservedreserved

INTEGER

non-reserved (cannot be function or type)reservedreservedreserved

INTEGRITY

non-reservednon-reserved

INTERSECT

reservedreservedreservedreserved

INTERSECTION

reservedreserved

INTERVAL

non-reserved (cannot be function or type)reservedreservedreserved

INTO

reservedreservedreservedreserved

INVOKER

non-reservednon-reservednon-reserved

IS

reserved (can be function or type)reservedreservedreserved

ISNULL

reserved (can be function or type)

ISOLATION

non-reservednon-reservednon-reservedreserved

JOIN

reserved (can be function or type)reservedreservedreserved

JSON

non-reserved

JSON_ARRAY

reserved

JSON_ARRAYAGG

reserved

JSON_EXISTS

reserved

JSON_OBJECT

reserved

JSON_OBJECTAGG

reserved

JSON_QUERY

reserved

JSON_TABLE

reserved

JSON_TABLE_PRIMITIVE

reserved

JSON_VALUE

reserved

K

non-reservednon-reserved

KEEP

non-reserved

KEY

non-reservednon-reservednon-reservedreserved

KEYS

non-reserved

KEY_MEMBER

non-reservednon-reserved

KEY_TYPE

non-reservednon-reserved

LABEL

non-reserved

LAG

reservedreserved

LANGUAGE

non-reservedreservedreservedreserved

LARGE

non-reservedreservedreserved

LAST

non-reservednon-reservednon-reservedreserved

LAST_VALUE

reservedreserved

LATERAL

reservedreservedreserved

LEAD

reservedreserved

LEADING

reservedreservedreservedreserved

LEAKPROOF

non-reserved

LEAST

non-reserved (cannot be function or type)

LEFT

reserved (can be function or type)reservedreservedreserved

LENGTH

non-reservednon-reservednon-reserved

LEVEL

non-reservednon-reservednon-reservedreserved

LIBRARY

non-reservednon-reserved

LIKE

reserved (can be function or type)reservedreservedreserved

LIKE_REGEX

reservedreserved

LIMIT

reservednon-reservednon-reserved

LINK

non-reservednon-reserved

LISTAGG

reserved

LISTEN

non-reserved

LN

reservedreserved

LOAD

non-reserved

LOCAL

non-reservedreservedreservedreserved

LOCALTIME

reservedreservedreserved

LOCALTIMESTAMP

reservedreservedreserved

LOCATION

non-reservednon-reservednon-reserved

LOCATOR

non-reservednon-reserved

LOCK

non-reserved

LOCKED

non-reserved

LOG

reserved

LOG10

reserved

LOGGED

non-reserved

LOWER

reservedreservedreserved

M

non-reservednon-reserved

MAP

non-reservednon-reserved

MAPPING

non-reservednon-reservednon-reserved

MATCH

non-reservedreservedreservedreserved

MATCHED

non-reservednon-reserved

MATCHES

reserved

MATCH_NUMBER

reserved

MATCH_RECOGNIZE

reserved

MATERIALIZED

non-reserved

MAX

reservedreservedreserved

MAXVALUE

non-reservednon-reservednon-reserved

MEASURES

reserved

MEMBER

reservedreserved

MERGE

reservedreserved

MESSAGE_LENGTH

non-reservednon-reservednon-reserved

MESSAGE_OCTET_LENGTH

non-reservednon-reservednon-reserved

MESSAGE_TEXT

non-reservednon-reservednon-reserved

METHOD

non-reservedreservedreserved

MIN

reservedreservedreserved

MINUTE

non-reservedreservedreservedreserved

MINVALUE

non-reservednon-reservednon-reserved

MOD

reservedreserved

MODE

non-reserved

MODIFIES

reservedreserved

MODULE

reservedreservedreserved

MONTH

non-reservedreservedreservedreserved

MORE

non-reservednon-reservednon-reserved

MOVE

non-reserved

MULTISET

reservedreserved

MUMPS

non-reservednon-reservednon-reserved

NAME

non-reservednon-reservednon-reservednon-reserved

NAMES

non-reservednon-reservednon-reservedreserved

NAMESPACE

non-reservednon-reserved

NATIONAL

non-reserved (cannot be function or type)reservedreservedreserved

NATURAL

reserved (can be function or type)reservedreservedreserved

NCHAR

non-reserved (cannot be function or type)reservedreservedreserved

NCLOB

reservedreserved

NESTED

non-reserved

NESTING

non-reservednon-reserved

NEW

non-reservedreservedreserved

NEXT

non-reservednon-reservednon-reservedreserved

NFC

non-reservednon-reservednon-reserved

NFD

non-reservednon-reservednon-reserved

NFKC

non-reservednon-reservednon-reserved

NFKD

non-reservednon-reservednon-reserved

NIL

non-reservednon-reserved

NO

non-reservedreservedreservedreserved

NONE

non-reserved (cannot be function or type)reservedreserved

NORMALIZE

non-reserved (cannot be function or type)reservedreserved

NORMALIZED

non-reservednon-reservednon-reserved

NOT

reservedreservedreservedreserved

NOTHING

non-reserved

NOTIFY

non-reserved

NOTNULL

reserved (can be function or type)

NOWAIT

non-reserved

NTH_VALUE

reservedreserved

NTILE

reservedreserved

NULL

reservedreservedreservedreserved

NULLABLE

non-reservednon-reservednon-reserved

NULLIF

non-reserved (cannot be function or type)reservedreservedreserved

NULLS

non-reservednon-reservednon-reserved

NUMBER

non-reservednon-reservednon-reserved

NUMERIC

non-reserved (cannot be function or type)reservedreservedreserved

OBJECT

non-reservednon-reservednon-reserved

OCCURRENCES_REGEX

reservedreserved

OCTETS

non-reservednon-reserved

OCTET_LENGTH

reservedreservedreserved

OF

non-reservedreservedreservedreserved

OFF

non-reservednon-reservednon-reserved

OFFSET

reservedreservedreserved

OIDS

non-reserved

OLD

non-reservedreservedreserved

OMIT

reserved

ON

reservedreservedreservedreserved

ONE

reserved

ONLY

reservedreservedreservedreserved

OPEN

reservedreservedreserved

OPERATOR

non-reserved

OPTION

non-reservednon-reservednon-reservedreserved

OPTIONS

non-reservednon-reservednon-reserved

OR

reservedreservedreservedreserved

ORDER

reservedreservedreservedreserved

ORDERING

non-reservednon-reserved

ORDINALITY

non-reservednon-reservednon-reserved

OTHERS

non-reservednon-reservednon-reserved

OUT

non-reserved (cannot be function or type)reservedreserved

OUTER

reserved (can be function or type)reservedreservedreserved

OUTPUT

non-reservednon-reservedreserved

OVER

non-reservedreservedreserved

OVERFLOW

non-reserved

OVERLAPS

reserved (can be function or type)reservedreservedreserved

OVERLAY

non-reserved (cannot be function or type)reservedreserved

OVERRIDING

non-reservednon-reservednon-reserved

OWNED

non-reserved

OWNER

non-reserved

P

non-reservednon-reserved

PAD

non-reservednon-reservedreserved

PARALLEL

non-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

PARSER

non-reserved

PARTIAL

non-reservednon-reservednon-reservedreserved

PARTITION

non-reservedreservedreserved

PASCAL

non-reservednon-reservednon-reserved

PASS

non-reserved

PASSING

non-reservednon-reservednon-reserved

PASSTHROUGH

non-reservednon-reserved

PASSWORD

non-reserved

PAST

non-reserved

PATH

non-reservednon-reserved

PATTERN

reserved

PER

reserved

PERCENT

reservedreserved

PERCENTILE_CONT

reservedreserved

PERCENTILE_DISC

reservedreserved

PERCENT_RANK

reservedreserved

PERIOD

reservedreserved

PERMISSION

non-reservednon-reserved

PERMUTE

reserved

PLACING

reservednon-reservednon-reserved

PLAN

non-reserved

PLANS

non-reserved

PLI

non-reservednon-reservednon-reserved

POLICY

non-reserved

PORTION

reservedreserved

POSITION

non-reserved (cannot be function or type)reservedreservedreserved

POSITION_REGEX

reservedreserved

POWER

reservedreserved

PRECEDES

reservedreserved

PRECEDING

non-reservednon-reservednon-reserved

PRECISION

non-reserved (cannot be function or type)reservedreservedreserved

PREPARE

non-reservedreservedreservedreserved

PREPARED

non-reserved

PRESERVE

non-reservednon-reservednon-reservedreserved

PRIMARY

reservedreservedreservedreserved

PRIOR

non-reservednon-reservednon-reservedreserved

PRIVATE

non-reserved

PRIVILEGES

non-reservednon-reservednon-reservedreserved

PROCEDURAL

non-reserved

PROCEDURE

non-reservedreservedreservedreserved

PROCEDURES

non-reserved

PROGRAM

non-reserved

PRUNE

non-reserved

PTF

reserved

PUBLIC

non-reservednon-reservedreserved

PUBLICATION

non-reserved

QUOTE

non-reserved

QUOTES

non-reserved

RANGE

non-reservedreservedreserved

RANK

reservedreserved

READ

non-reservednon-reservednon-reservedreserved

READS

reservedreserved

REAL

non-reserved (cannot be function or type)reservedreservedreserved

REASSIGN

non-reserved

RECHECK

non-reserved

RECOVERY

non-reservednon-reserved

RECURSIVE

non-reservedreservedreserved

REF

non-reservedreservedreserved

REFERENCES

reservedreservedreservedreserved

REFERENCING

non-reservedreservedreserved

REFRESH

non-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

REINDEX

non-reserved

RELATIVE

non-reservednon-reservednon-reservedreserved

RELEASE

non-reservedreservedreserved

RENAME

non-reserved

REPEATABLE

non-reservednon-reservednon-reservednon-reserved

REPLACE

non-reserved

REPLICA

non-reserved

REQUIRING

non-reservednon-reserved

RESET

non-reserved

RESPECT

non-reservednon-reserved

RESTART

non-reservednon-reservednon-reserved

RESTORE

non-reservednon-reserved

RESTRICT

non-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

RETURNING

reservednon-reservednon-reserved

RETURNS

non-reservedreservedreserved

REVOKE

non-reservedreservedreservedreserved

RIGHT

reserved (can be function or type)reservedreservedreserved

ROLE

non-reservednon-reservednon-reserved

ROLLBACK

non-reservedreservedreservedreserved

ROLLUP

non-reservedreservedreserved

ROUTINE

non-reservednon-reservednon-reserved

ROUTINES

non-reserved

ROUTINE_CATALOG

non-reservednon-reserved

ROUTINE_NAME

non-reservednon-reserved

ROUTINE_SCHEMA

non-reservednon-reserved

ROW

non-reserved (cannot be function or type)reservedreserved

ROWS

non-reservedreservedreservedreserved

ROW_COUNT

non-reservednon-reservednon-reserved

ROW_NUMBER

reservedreserved

RULE

non-reserved

RUNNING

reserved

SAVEPOINT

non-reservedreservedreserved

SCALAR

non-reserved

SCALE

non-reservednon-reservednon-reserved

SCHEMA

non-reservednon-reservednon-reservedreserved

SCHEMAS

non-reserved

SCHEMA_NAME

non-reservednon-reservednon-reserved

SCOPE

reservedreserved

SCOPE_CATALOG

non-reservednon-reserved

SCOPE_NAME

non-reservednon-reserved

SCOPE_SCHEMA

non-reservednon-reserved

SCROLL

non-reservedreservedreservedreserved

SEARCH

non-reservedreservedreserved

SECOND

non-reservedreservedreservedreserved

SECTION

non-reservednon-reservedreserved

SECURITY

non-reservednon-reservednon-reserved

SEEK

reserved

SELECT

reservedreservedreservedreserved

SELECTIVE

non-reservednon-reserved

SELF

non-reservednon-reserved

SENSITIVE

reservedreserved

SEQUENCE

non-reservednon-reservednon-reserved

SEQUENCES

non-reserved

SERIALIZABLE

non-reservednon-reservednon-reservednon-reserved

SERVER

non-reservednon-reservednon-reserved

SERVER_NAME

non-reservednon-reservednon-reserved

SESSION

non-reservednon-reservednon-reservedreserved

SESSION_USER

reservedreservedreservedreserved

SET

non-reservedreservedreservedreserved

SETOF

non-reserved (cannot be function or type)

SETS

non-reservednon-reservednon-reserved

SHARE

non-reserved

SHOW

non-reservedreserved

SIMILAR

reserved (can be function or type)reservedreserved

SIMPLE

non-reservednon-reservednon-reserved

SIN

reserved

SINH

reserved

SIZE

non-reservednon-reservedreserved

SKIP

non-reservedreserved

SMALLINT

non-reserved (cannot be function or type)reservedreservedreserved

SNAPSHOT

non-reserved

SOME

reservedreservedreservedreserved

SOURCE

non-reservednon-reserved

SPACE

non-reservednon-reservedreserved

SPECIFIC

reservedreserved

SPECIFICTYPE

reservedreserved

SPECIFIC_NAME

non-reservednon-reserved

SQL

non-reservedreservedreservedreserved

SQLCODE

reserved

SQLERROR

reserved

SQLEXCEPTION

reservedreserved

SQLSTATE

reservedreservedreserved

SQLWARNING

reservedreserved

SQRT

reservedreserved

STABLE

non-reserved

STANDALONE

non-reservednon-reservednon-reserved

START

non-reservedreservedreserved

STATE

non-reservednon-reserved

STATEMENT

non-reservednon-reservednon-reserved

STATIC

reservedreserved

STATISTICS

non-reserved

STDDEV_POP

reservedreserved

STDDEV_SAMP

reservedreserved

STDIN

non-reserved

STDOUT

non-reserved

STORAGE

non-reserved

STORED

non-reserved

STRICT

non-reserved

STRING

non-reserved

STRIP

non-reservednon-reservednon-reserved

STRUCTURE

non-reservednon-reserved

STYLE

non-reservednon-reserved

SUBCLASS_ORIGIN

non-reservednon-reservednon-reserved

SUBMULTISET

reservedreserved

SUBSCRIPTION

non-reserved

SUBSET

reserved

SUBSTRING

non-reserved (cannot be function or type)reservedreservedreserved

SUBSTRING_REGEX

reservedreserved

SUCCEEDS

reservedreserved

SUM

reservedreservedreserved

SUPPORT

non-reserved

SYMMETRIC

reservedreservedreserved

SYSID

non-reserved

SYSTEM

non-reservedreservedreserved

SYSTEM_TIME

reservedreserved

SYSTEM_USER

reservedreservedreserved

T

non-reservednon-reserved

TABLE

reservedreservedreservedreserved

TABLES

non-reserved

TABLESAMPLE

reserved (can be function or type)reservedreserved

TABLESPACE

non-reserved

TABLE_NAME

non-reservednon-reservednon-reserved

TAN

reserved

TANH

reserved

TEMP

non-reserved

TEMPLATE

non-reserved

TEMPORARY

non-reservednon-reservednon-reservedreserved

TEXT

non-reserved

THEN

reservedreservedreservedreserved

THROUGH

non-reserved

TIES

non-reservednon-reservednon-reserved

TIME

non-reserved (cannot be function or type)reservedreservedreserved

TIMESTAMP

non-reserved (cannot be function or type)reservedreservedreserved

TIMEZONE_HOUR

reservedreservedreserved

TIMEZONE_MINUTE

reservedreservedreserved

TO

reservedreservedreservedreserved

TOKEN

non-reservednon-reserved

TOP_LEVEL_COUNT

non-reservednon-reserved

TRAILING

reservedreservedreservedreserved

TRANSACTION

non-reservednon-reservednon-reservedreserved

TRANSACTIONS_​COMMITTED

non-reservednon-reserved

TRANSACTIONS_​ROLLED_​BACK

non-reservednon-reserved

TRANSACTION_ACTIVE

non-reservednon-reserved

TRANSFORM

non-reservednon-reservednon-reserved

TRANSFORMS

non-reservednon-reserved

TRANSLATE

reservedreservedreserved

TRANSLATE_REGEX

reservedreserved

TRANSLATION

reservedreservedreserved

TREAT

non-reserved (cannot be function or type)reservedreserved

TRIGGER

non-reservedreservedreserved

TRIGGER_CATALOG

non-reservednon-reserved

TRIGGER_NAME

non-reservednon-reserved

TRIGGER_SCHEMA

non-reservednon-reserved

TRIM

non-reserved (cannot be function or type)reservedreservedreserved

TRIM_ARRAY

reservedreserved

TRUE

reservedreservedreservedreserved

TRUNCATE

non-reservedreservedreserved

TRUSTED

non-reserved

TYPE

non-reservednon-reservednon-reservednon-reserved

TYPES

non-reserved

UESCAPE

non-reservedreservedreserved

UNBOUNDED

non-reservednon-reservednon-reserved

UNCOMMITTED

non-reservednon-reservednon-reservednon-reserved

UNCONDITIONAL

non-reserved

UNDER

non-reservednon-reserved

UNENCRYPTED

non-reserved

UNION

reservedreservedreservedreserved

UNIQUE

reservedreservedreservedreserved

UNKNOWN

non-reservedreservedreservedreserved

UNLINK

non-reservednon-reserved

UNLISTEN

non-reserved

UNLOGGED

non-reserved

UNMATCHED

reserved

UNNAMED

non-reservednon-reservednon-reserved

UNNEST

reservedreserved

UNTIL

non-reserved

UNTYPED

non-reservednon-reserved

UPDATE

non-reservedreservedreservedreserved

UPPER

reservedreservedreserved

URI

non-reservednon-reserved

USAGE

non-reservednon-reservedreserved

USER

reservedreservedreservedreserved

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

USING

reservedreservedreservedreserved

UTF16

non-reserved

UTF32

non-reserved

UTF8

non-reserved

VACUUM

non-reserved

VALID

non-reservednon-reservednon-reserved

VALIDATE

non-reserved

VALIDATOR

non-reserved

VALUE

non-reservedreservedreservedreserved

VALUES

non-reserved (cannot be function or type)reservedreservedreserved

VALUE_OF

reservedreserved

VARBINARY

reservedreserved

VARCHAR

non-reserved (cannot be function or type)reservedreservedreserved

VARIADIC

reserved

VARYING

non-reservedreservedreservedreserved

VAR_POP

reservedreserved

VAR_SAMP

reservedreserved

VERBOSE

reserved (can be function or type)

VERSION

non-reservednon-reservednon-reserved

VERSIONING

reservedreserved

VIEW

non-reservednon-reservednon-reservedreserved

VIEWS

non-reserved

VOLATILE

non-reserved

WHEN

reservedreservedreservedreserved

WHENEVER

reservedreservedreserved

WHERE

reservedreservedreservedreserved

WHITESPACE

non-reservednon-reservednon-reserved

WIDTH_BUCKET

reservedreserved

WINDOW

reservedreservedreserved

WITH

reservedreservedreservedreserved

WITHIN

non-reservedreservedreserved

WITHOUT

non-reservedreservedreserved

WORK

non-reservednon-reservednon-reservedreserved

WRAPPER

non-reservednon-reservednon-reserved

WRITE

non-reservednon-reservednon-reservedreserved

XML

non-reservedreservedreserved

XMLAGG

reservedreserved

XMLATTRIBUTES

non-reserved (cannot be function or type)reservedreserved

XMLBINARY

reservedreserved

XMLCAST

reservedreserved

XMLCOMMENT

reservedreserved

XMLCONCAT

non-reserved (cannot be function or type)reservedreserved

XMLDECLARATION

non-reservednon-reserved

XMLDOCUMENT

reservedreserved

XMLELEMENT

non-reserved (cannot be function or type)reservedreserved

XMLEXISTS

non-reserved (cannot be function or type)reservedreserved

XMLFOREST

non-reserved (cannot be function or type)reservedreserved

XMLITERATE

reservedreserved

XMLNAMESPACES

non-reserved (cannot be function or type)reservedreserved

XMLPARSE

non-reserved (cannot be function or type)reservedreserved

XMLPI

non-reserved (cannot be function or type)reservedreserved

XMLQUERY

reservedreserved

XMLROOT

non-reserved (cannot be function or type)

XMLSCHEMA

non-reservednon-reserved

XMLSERIALIZE

non-reserved (cannot be function or type)reservedreserved

XMLTABLE

non-reserved (cannot be function or type)reservedreserved

XMLTEXT

reservedreserved

XMLVALIDATE

reservedreserved

YEAR

non-reservedreservedreservedreserved

YES

non-reservednon-reservednon-reserved

ZONE

non-reservednon-reservednon-reservedreserved