Keywords

The SQL contains reserved and non-reserved words. Standards require that reserved keywords not be used as other identifiers. Non-reserved keywords have special meanings only in a specific environment and can be used as identifiers in other environments.

The naming rules for identifiers are as follows:

  • An identifier name can only contain letters, underscores, digits (0-9), and dollar signs ($).

  • An identifier name must start with a letter (a to z) or an underscore (_).

    NOTE:

    • The naming rules are recommended but not mandatory.
    • In special cases, double quotation marks can be used to avoid special character errors.

Table 1 SQL keywords

Keyword

openGauss

SQL:1999

SQL-92

ABORT

Non-reserved

-

-

ABS

-

Non-reserved

-

ABSOLUTE

Non-reserved

Reserved

Reserved

ACCESS

Non-reserved

-

-

ACCOUNT

Non-reserved

-

-

ACTION

Non-reserved

Reserved

Reserved

ADA

-

Non-reserved

Non-reserved

ADD

Non-reserved

Reserved

Reserved

ADMIN

Non-reserved

Reserved

-

AFTER

Non-reserved

Reserved

-

AGGREGATE

Non-reserved

Reserved

-

ALGORITHM

Non-reserved

-

-

ALIAS

-

Reserved

-

ALL

Reserved

Reserved

Reserved

ALLOCATE

-

Reserved

Reserved

ALSO

Non-reserved

-

-

ALTER

Non-reserved

Reserved

Reserved

ALWAYS

Non-reserved

-

-

ANALYSE

Reserved

-

-

ANALYZE

Reserved

-

-

AND

Reserved

Reserved

Reserved

ANY

Reserved

Reserved

Reserved

APP

Non-reserved

-

-

ARE

-

Reserved

Reserved

ARRAY

Reserved

Reserved

-

AS

Reserved

Reserved

Reserved

ASC

Reserved

Reserved

Reserved

ASENSITIVE

-

Non-reserved

-

ASSERTION

Non-reserved

Reserved

Reserved

ASSIGNMENT

Non-reserved

Non-reserved

-

ASYMMETRIC

Reserved

Non-reserved

-

AT

Non-reserved

Reserved

Reserved

ATOMIC

-

Non-reserved

-

ATTRIBUTE

Non-reserved

-

-

AUTHID

Reserved

-

-

AUTHORIZATION

Reserved (functions and types allowed)

Reserved

Reserved

AUTOEXTEND

Non-reserved

-

-

AUTOMAPPED

Non-reserved

-

-

AVG

-

Non-reserved

Reserved

BACKWARD

Non-reserved

-

-

BARRIER

Non-reserved

-

-

BEFORE

Non-reserved

Reserved

-

BEGIN

Non-reserved

Reserved

Reserved

BEGIN_NON_ANOYBLOCK

Non-reserved

-

-

BETWEEN

Non-reserved (excluding functions and types)

Non-reserved

Reserved

BIGINT

Non-reserved (excluding functions and types)

-

-

BINARY

Reserved (functions and types allowed)

Reserved

-

BINARY_DOUBLE

Non-reserved (excluding functions and types)

-

-

BINARY_INTEGER

Non-reserved (excluding functions and types)

-

-

BIT

Non-reserved (excluding functions and types)

Reserved

Reserved

BITVAR

-

Non-reserved

-

BIT_LENGTH

-

Non-reserved

Reserved

BLOB

Non-reserved

Reserved

-

BOOLEAN

Non-reserved (excluding functions and types)

Reserved

-

BOTH

Reserved

Reserved

Reserved

BUCKETS

Reserved

-

-

BREADTH

-

Reserved

-

BY

Non-reserved

Reserved

Reserved

BYTEAWITHOUTODER

Non-reserved

-

-

BYTEAWITHOUTORDERWITHEQUAL

Non-reserved

-

-

C

-

Non-reserved

Non-reserved

CACHE

Non-reserved

-

-

CALL

Non-reserved

Reserved

-

CALLED

Non-reserved

Non-reserved

-

CARDINALITY

-

Non-reserved

-

CASCADE

Non-reserved

Reserved

Reserved

CASCADED

Non-reserved

Reserved

Reserved

CASE

Reserved

Reserved

Reserved

CAST

Reserved

Reserved

Reserved

CATALOG

Non-reserved

Reserved

Reserved

CATALOG_NAME

-

Non-reserved

Non-reserved

CHAIN

Non-reserved

Non-reserved

-

CHAR

Non-reserved (excluding functions and types)

Reserved

Reserved

CHARACTER

Non-reserved (excluding functions and types)

Reserved

Reserved

CHARACTERISTICS

Non-reserved

-

-

CHARACTER_LENGTH

-

Non-reserved

Reserved

CHARACTER_SET_CATALOG

-

Non-reserved

Non-reserved

CHARACTER_SET_NAME

-

Non-reserved

Non-reserved

CHARACTER_SET_SCHEMA

-

Non-reserved

Non-reserved

CHAR_LENGTH

-

Non-reserved

Reserved

CHECK

Reserved

Reserved

Reserved

CHECKED

-

Non-reserved

-

CHECKPOINT

Non-reserved

-

-

CLASS

Non-reserved

Reserved

-

CLEAN

Non-reserved

-

-

CLASS_ORIGIN

-

Non-reserved

Non-reserved

CLIENT

Non-reserved

-

-

CLIENT_MASTER_KEY

Non-reserved

-

-

CLIENT_MASTER_KEYS

Non-reserved

-

-

CLOB

Non-reserved

Reserved

-

CLOSE

Non-reserved

Reserved

Reserved

CLUSTER

Non-reserved

-

-

COALESCE

Non-reserved (excluding functions and types)

Non-reserved

Reserved

COBOL

-

Non-reserved

Non-reserved

COLLATE

Reserved

Reserved

Reserved

COLLATION

Reserved (functions and types allowed)

Reserved

Reserved

COLLATION_CATALOG

-

Non-reserved

Non-reserved

COLLATION_NAME

-

Non-reserved

Non-reserved

COLLATION_SCHEMA

-

Non-reserved

Non-reserved

COLUMN

Reserved

Reserved

Reserved

COLUMN_ARGS

Non-reserved

-

-

COLUMN_ENCRYPTION_KEY

Non-reserved

-

-

COLUMN_ENCRYPTION_KEYS

Non-reserved

-

-

COLUMN_FUNCTION

Non-reserved

-

-

COLUMN_NAME

-

Non-reserved

Non-reserved

COMPACT

Reserved (functions and types allowed)

-

-

COMPATIBLE_ILLEGAL_CHARS

Non-reserved

-

-

COMMAND_FUNCTION

-

Non-reserved

Non-reserved

COMPLETE

Non-reserved

-

-

COMMAND_FUNCTION_CODE

-

Non-reserved

-

COMMENT

Non-reserved

-

-

COMMENTS

Non-reserved

-

-

COMMIT

Non-reserved

Reserved

Reserved

COMMITTED

Non-reserved

Non-reserved

Non-reserved

COMPRESS

Non-reserved

-

-

COMPLETION

-

Reserved

-

CONCURRENTLY

Reserved (functions and types allowed)

-

-

CONDITION

-

-

-

CONDITION_NUMBER

-

Non-reserved

Non-reserved

CONFIGURATION

Non-reserved

-

-

CONNECT

-

Reserved

Reserved

CONNECTION

Non-reserved

Reserved

Reserved

CONNECTION_NAME

-

Non-reserved

Non-reserved

CONSTRAINT

Reserved

Reserved

Reserved

CONSTRAINTS

Non-reserved

Reserved

Reserved

CONSTRAINT_CATALOG

-

Non-reserved

Non-reserved

CONSTRAINT_NAME

-

Non-reserved

Non-reserved

CONSTRAINT_SCHEMA

-

Non-reserved

Non-reserved

CONSTRUCTOR

-

Reserved

-

CONTAINS

-

Non-reserved

-

CONTENT

Non-reserved

-

-

CONTINUE

Non-reserved

Reserved

Reserved

CONVERSION

Non-reserved

-

-

CONVERT

-

Non-reserved

Reserved

COORDINATOR

Non-reserved

-

-

COPY

Non-reserved

-

-

CORRESPONDING

-

Reserved

Reserved

COST

Non-reserved

-

-

COUNT

-

Non-reserved

Reserved

CREATE

Reserved

Reserved

Reserved

CROSS

Reserved (functions and types allowed)

Reserved

Reserved

CSV

Non-reserved

-

-

CUBE

Non-reserved

Reserved

-

CURRENT

Non-reserved

Reserved

Reserved

CURRENT_CATALOG

Reserved

-

-

CURRENT_DATE

Reserved

Reserved

Reserved

CURRENT_PATH

-

Reserved

-

CURRENT_ROLE

Reserved

Reserved

-

CURRENT_SCHEMA

Reserved (functions and types allowed)

-

-

CURRENT_TIME

Reserved

Reserved

Reserved

CURRENT_TIMESTAMP

Reserved

Reserved

Reserved

CURRENT_USER

Reserved

Reserved

Reserved

CURSOR

Non-reserved

Reserved

Reserved

CURSOR_NAME

-

Non-reserved

Non-reserved

CYCLE

Non-reserved

Reserved

-

DATA

Non-reserved

Reserved

Non-reserved

DATABASE

Non-reserved

-

-

DATAFILE

Non-reserved

-

-

DATE_FORMAT

Non-reserved

-

-

DATATYPE_CL

Non-reserved

    

DATE

Non-reserved (excluding functions and types)

Reserved

Reserved

DELTAMERGE

Reserved (functions and types allowed)

-

-

DATETIME_INTERVAL_CODE

-

Non-reserved

Non-reserved

DATETIME_INTERVAL_PRECISION

-

Non-reserved

Non-reserved

DAY

Non-reserved

Reserved

Reserved

DBCOMPATIBILITY

Non-reserved

-

-

DEALLOCATE

Non-reserved

Reserved

Reserved

DEC

Non-reserved (excluding functions and types)

Reserved

Reserved

DECIMAL

Non-reserved (excluding functions and types)

Reserved

Reserved

DECLARE

Non-reserved

Reserved

Reserved

DECODE

Non-reserved (excluding functions and types)

-

-

DEFAULT

Reserved

Reserved

Reserved

DEFAULTS

Non-reserved

-

-

DEFERRABLE

Reserved

Reserved

Reserved

DEFERRED

Non-reserved

Reserved

Reserved

DEFINED

-

Non-reserved

-

DEFINER

Non-reserved

Non-reserved

-

DELETE

Non-reserved

Reserved

Reserved

DELIMITER

Non-reserved

-

-

DELIMITERS

Non-reserved

-

-

DELTA

Non-reserved

-

-

DEPTH

-

Reserved

-

DEREF

-

Reserved

-

DESC

Reserved

Reserved

Reserved

DESCRIBE

-

Reserved

Reserved

DESCRIPTOR

-

Reserved

Reserved

DESTROY

-

Reserved

-

DESTRUCTOR

-

Reserved

-

DETERMINISTIC

Non-reserved

Reserved

-

DIAGNOSTICS

-

Reserved

Reserved

DICTIONARY

Non-reserved

Reserved

-

DIRECT

Non-reserved

-

-

DIRECTORY

Non-reserved

-

-

DISABLE

Non-reserved

-

-

DISCARD

Non-reserved

-

-

DISCONNECT

Non-reserved

Reserved

Reserved

DISPATCH

-

Non-reserved

-

DISTINCT

Reserved

Reserved

Reserved

DISTRIBUTE

Non-reserved

-

-

DISTRIBUTION

Non-reserved

-

-

DO

Reserved

-

-

DOCUMENT

Non-reserved

-

-

DOMAIN

Non-reserved

Reserved

Reserved

DOUBLE

Non-reserved

Reserved

Reserved

DROP

Non-reserved

Reserved

Reserved

DUPLICATE

Non-reserved

-

-

DYNAMIC

-

Reserved

-

DYNAMIC_FUNCTION

-

Non-reserved

Non-reserved

DYNAMIC_FUNCTION_CODE

-

Non-reserved

-

EACH

Non-reserved

Reserved

-

ELSE

Reserved

Reserved

Reserved

ELASTIC

Non-reserved

-

-

ENABLE

Non-reserved

-

-

ENCODING

Non-reserved

-

-

ENCRYPTED

Non-reserved

-

-

ENCRYPTED_VALUE

Non-reserved

-

-

ENCRYPTION

Non-reserved

-

-

ENCRYPTION_TYPE

Non-reserved

-

-

END

Reserved

Reserved

Reserved

END-EXEC

-

Reserved

Reserved

ENFORCED

Non-reserved

-

-

ENUM

Non-reserved

-

-

EOL

Non-reserved

-

-

ERRORS

Non-reserved

-

-

EQUALS

-

Reserved

-

ESCAPE

Non-reserved

Reserved

Reserved

ESCAPING

Non-reserved

-

-

EVERY

Non-reserved

Reserved

-

EXCEPT

Reserved

Reserved

Reserved

EXCEPTION

-

Reserved

Reserved

EXCHANGE

Non-reserved

-

-

EXCLUDE

Non-reserved

-

-

EXCLUDED

Reserved

-

-

EXCLUDING

Non-reserved

-

-

EXCLUSIVE

Non-reserved

-

-

EXEC

-

Reserved

Reserved

EXECUTE

Non-reserved

Reserved

Reserved

EXISTING

-

Non-reserved

-

EXISTS

Non-reserved (excluding functions and types)

Non-reserved

Reserved

EXPIRED_P

Non-reserved

-

-

EXPLAIN

Non-reserved

-

-

EXTENSION

Non-reserved

-

-

EXTERNAL

Non-reserved

Reserved

Reserved

EXTRACT

Non-reserved (excluding functions and types)

Non-reserved

Reserved

FALSE

Reserved

Reserved

Reserved

FAMILY

Non-reserved

-

-

FAST

Non-reserved

-

-

FETCH

Reserved

Reserved

Reserved

FENCED

Reserved

-

-

FILEHEADER

Non-reserved

-

-

FINAL

-

Non-reserved

-

FIRST

Non-reserved

Reserved

Reserved

FIXED

Non-reserved

Reserved

Reserved

FILL_MISSING_FIELDS

Non-reserved

-

-

FLOAT

Non-reserved (excluding functions and types)

Reserved

Reserved

FOLLOWING

Non-reserved

-

-

FOR

Reserved

Reserved

Reserved

FORCE

Non-reserved

-

-

FOREIGN

Reserved

Reserved

Reserved

FORMATTER

Non-reserved

-

-

FORTRAN

-

Non-reserved

Non-reserved

FORWARD

Non-reserved

-

-

FOUND

-

Reserved

Reserved

FREE

-

Reserved

-

FREEZE

Reserved (functions and types allowed)

-

-

FROM

Reserved

Reserved

Reserved

FULL

Reserved (functions and types allowed)

Reserved

Reserved

FUNCTION

Non-reserved

Reserved

-

FUNCTIONS

Non-reserved

-

-

G

-

Non-reserved

-

GENERAL

-

Reserved

-

GENERATED

-

Non-reserved

-

GET

-

Reserved

Reserved

GLOBAL

Non-reserved

Reserved

Reserved

GLOBAL_FUNCTION

Non-reserved

-

-

GO

-

Reserved

Reserved

GOTO

-

Reserved

Reserved

GRANT

Reserved

Reserved

Reserved

GRANTED

Non-reserved

Non-reserved

-

GREATEST

Non-reserved (excluding functions and types)

-

-

GROUP

Reserved

Reserved

Reserved

GROUPING

Non-reserved (excluding functions and types)

Reserved

-

HANDLER

Non-reserved

-

-

HAVING

Reserved

Reserved

Reserved

HDFSDIRECTORY

Reserved (functions and types allowed)

-

-

HEADER

Non-reserved

-

-

HIERARCHY

-

Non-reserved

-

HOLD

Non-reserved

Non-reserved

-

HOST

-

Reserved

-

HOUR

Non-reserved

Reserved

Reserved

IDENTIFIED

Non-reserved

-

-

IDENTITY

Non-reserved

Reserved

Reserved

IF

Non-reserved

-

-

IGNORE

-

Reserved

-

IGNORE_EXTRA_DATA

Non-reserved

-

-

ILIKE

Reserved (functions and types allowed)

-

-

IMMEDIATE

Non-reserved

Reserved

Reserved

IMMUTABLE

Non-reserved

-

-

IMPLEMENTATION

-

Non-reserved

-

IMPLICIT

Non-reserved

-

-

IN

Reserved

Reserved

Reserved

INTERNAL

Non-reserved

-

-

INCLUDING

Non-reserved

-

-

INCREMENT

Non-reserved

-

-

INDEX

Non-reserved

-

-

INDEXES

Non-reserved

-

-

INDICATOR

-

Reserved

Reserved

INFIX

-

Non-reserved

-

INHERIT

Non-reserved

-

-

INHERITS

Non-reserved

-

-

INITIAL

Non-reserved

-

-

INITIALIZE

-

Reserved

-

INITIALLY

Reserved

Reserved

Reserved

INITRANS

Non-reserved

-

-

INLINE

Non-reserved

-

-

INNER

Reserved (functions and types allowed)

Reserved

Reserved

INOUT

Non-reserved (excluding functions and types)

Reserved

-

INPUT

Non-reserved

Reserved

Reserved

INSENSITIVE

Non-reserved

Non-reserved

Reserved

INSERT

Non-reserved

Reserved

Reserved

INSTANCE

-

Non-reserved

-

INSTANTIABLE

-

Non-reserved

-

INSTEAD

Non-reserved

-

-

INT

Non-reserved (excluding functions and types)

Reserved

Reserved

INTEGER

Non-reserved (excluding functions and types)

Reserved

Reserved

INTERSECT

Reserved

Reserved

Reserved

INTERVAL

Non-reserved (excluding functions and types)

Reserved

Reserved

INTO

Reserved

Reserved

Reserved

INVOKER

Non-reserved

Non-reserved

-

IS

Reserved

Reserved

Reserved

ISNULL

Non-reserved

-

-

ISOLATION

Non-reserved

Reserved

Reserved

ITERATE

-

Reserved

-

JOIN

Reserved (functions and types allowed)

Reserved

Reserved

K

-

Non-reserved

-

KEY

Non-reserved

Reserved

Reserved

KEY_PATH

Non-reserved

-

-

KEY_MEMBER

-

Non-reserved

-

KEY_STORE

Non-reserved

-

-

KEY_TYPE

-

Non-reserved

-

KILL

Non-reserved

-

-

LABEL

Non-reserved

-

-

LANGUAGE

Non-reserved

Reserved

Reserved

LARGE

Non-reserved

Reserved

-

LAST

Non-reserved

Reserved

Reserved

LATERAL

-

Reserved

-

LC_COLLATE

Non-reserved

-

-

LC_CTYPE

Non-reserved

-

-

LEADING

Reserved

Reserved

Reserved

LEAKPROOF

Non-reserved

-

-

LEAST

Non-reserved (excluding functions and types)

-

-

LEFT

Reserved (functions and types allowed)

Reserved

Reserved

LENGTH

-

Non-reserved

Non-reserved

LESS

Reserved

Reserved

-

LEVEL

Non-reserved

Reserved

Reserved

LIKE

Reserved (functions and types allowed)

Reserved

Reserved

LIMIT

Reserved

Reserved

-

LISTEN

Non-reserved

-

-

LOAD

Non-reserved

-

-

LOCAL

Non-reserved

Reserved

Reserved

LOCALTIME

Reserved

Reserved

-

LOCALTIMESTAMP

Reserved

Reserved

-

LOCATION

Non-reserved

-

-

LOCATOR

-

Reserved

-

LOCK

Non-reserved

-

-

LOG

Non-reserved

-

-

LOGGING

Non-reserved

-

-

LOOP

Non-reserved

-

-

LOWER

-

Non-reserved

Reserved

MAP

-

Reserved

-

MAPPING

Non-reserved

-

-

MASTER

Non-reserved

-

-

MATCH

Non-reserved

Reserved

Reserved

MATCHED

Non-reserved

-

-

MAX

-

Non-reserved

Reserved

MAXEXTENTS

Non-reserved

-

-

MAXSIZE

Non-reserved

-

-

MAXTRANS

Non-reserved

-

-

MAXVALUE

Reserved

-

-

MERGE

Non-reserved

-

-

MESSAGE_LENGTH

-

Non-reserved

Non-reserved

MESSAGE_OCTET_LENGTH

-

Non-reserved

Non-reserved

MESSAGE_TEXT

-

Non-reserved

Non-reserved

METHOD

-

Non-reserved

-

MIN

-

Non-reserved

Reserved

MINEXTENTS

Non-reserved

-

-

MINUS

Reserved

-

-

MINUTE

Non-reserved

Reserved

Reserved

MINVALUE

Non-reserved

-

-

MOD

-

Non-reserved

-

MODE

Non-reserved

-

-

MODIFIES

-

Reserved

-

MODIFY

Reserved

Reserved

-

MODULE

-

Reserved

Reserved

MONTH

Non-reserved

Reserved

Reserved

MORE

-

Non-reserved

Non-reserved

MOVE

Non-reserved

-

-

MOVEMENT

Non-reserved

-

-

MUMPS

-

Non-reserved

Non-reserved

NAME

Non-reserved

Non-reserved

Non-reserved

NAMES

Non-reserved

Reserved

Reserved

NATIONAL

Non-reserved (excluding functions and types)

Reserved

Reserved

NATURAL

Reserved (functions and types allowed)

Reserved

Reserved

NCHAR

Non-reserved (excluding functions and types)

Reserved

Reserved

NCLOB

-

Reserved

-

NEW

-

Reserved

-

NEXT

Non-reserved

Reserved

Reserved

NLSSORT

Reserved

-

-

NO

Non-reserved

Reserved

Reserved

NOCOMPRESS

Non-reserved

-

-

NOCYCLE

Non-reserved

-

-

NODE

Non-reserved

-

-

NOLOGGING

Non-reserved

-

-

NOMAXVALUE

Non-reserved

-

-

NOMINVALUE

Non-reserved

-

-

NONE

Non-reserved (excluding functions and types)

Reserved

-

NOT

Reserved

Reserved

Reserved

NOTHING

Non-reserved

-

-

NOTIFY

Non-reserved

-

-

NOTNULL

Reserved (functions and types allowed)

-

-

NOWAIT

Non-reserved

-

-

NULL

Reserved

Reserved

Reserved

NULLABLE

-

Non-reserved

Non-reserved

NULLIF

Non-reserved (excluding functions and types)

Non-reserved

Reserved

NULLS

Non-reserved

-

-

NUMBER

Non-reserved (excluding functions and types)

Non-reserved

Non-reserved

NUMERIC

Non-reserved (excluding functions and types)

Reserved

Reserved

NUMSTR

Non-reserved

-

-

NVARCHAR2

Non-reserved (excluding functions and types)

-

-

NVL

Non-reserved (excluding functions and types)

-

-

OBJECT

Non-reserved

Reserved

-

OCTET_LENGTH

-

Non-reserved

Reserved

OF

Non-reserved

Reserved

Reserved

OFF

Non-reserved

Reserved

-

OFFSET

Reserved

-

-

OIDS

Non-reserved

-

-

OLD

-

Reserved

-

ON

Reserved

Reserved

Reserved

ONLY

Reserved

Reserved

Reserved

OPEN

-

Reserved

Reserved

OPERATION

-

Reserved

-

OPERATOR

Non-reserved

-

-

OPTIMIZATION

Non-reserved

-

-

OPTION

Non-reserved

Reserved

Reserved

OPTIONS

Non-reserved

Non-reserved

-

OR

Reserved

Reserved

Reserved

ORDER

Reserved

Reserved

Reserved

ORDINALITY

-

Reserved

-

OUT

Non-reserved (excluding functions and types)

Reserved

-

OUTER

Reserved (functions and types allowed)

Reserved

Reserved

OUTPUT

-

Reserved

Reserved

OVER

Non-reserved

-

-

OVERLAPS

Reserved (functions and types allowed)

Non-reserved

Reserved

OVERLAY

Non-reserved (excluding functions and types)

Non-reserved

-

OVERRIDING

-

Non-reserved

-

OWNED

Non-reserved

-

-

OWNER

Non-reserved

-

-

PACKAGE

Non-reserved

-

-

PAD

-

Reserved

Reserved

PARAMETER

-

Reserved

-

PARAMETERS

-

Reserved

-

PARAMETER_MODE

-

Non-reserved

-

PARAMETER_NAME

-

Non-reserved

-

PARAMETER_ORDINAL_POSITION

-

Non-reserved

-

PARAMETER_SPECIFIC_CATALOG

-

Non-reserved

-

PARAMETER_SPECIFIC_NAME

-

Non-reserved

-

PARAMETER_SPECIFIC_SCHEMA

-

Non-reserved

-

PARSER

Non-reserved

-

-

PARTIAL

Non-reserved

Reserved

Reserved

PARTITION

Non-reserved

-

-

PARTITIONS

Non-reserved

-

-

PASCAL

-

Non-reserved

Non-reserved

PASSING

Non-reserved

-

-

PASSWORD

Non-reserved

-

-

PATH

-

Reserved

-

PCTFREE

Non-reserved

-

-

PER

Non-reserved

-

-

PERM

Non-reserved

-

-

PERCENT

Non-reserved

-

-

PERFORMANCE

Reserved

-

-

PLACING

Reserved

-

-

PLAN

Non-reserved

    

PLANS

Non-reserved

-

-

PLI

-

Non-reserved

Non-reserved

POOL

Non-reserved

-

-

POLICY

Non-reserved

-

-

POSITION

Non-reserved (excluding functions and types)

Non-reserved

Reserved

POSTFIX

-

Reserved

-

PRECEDING

Non-reserved

-

-

PRECISION

Non-reserved (excluding functions and types)

Reserved

Reserved

PREFERRED

Non-reserved

-

-

PREFIX

Non-reserved

Reserved

-

PREORDER

-

Reserved

-

PREPARE

Non-reserved

Reserved

Reserved

PREPARED

Non-reserved

-

-

PRESERVE

Non-reserved

Reserved

Reserved

PRIMARY

Reserved

Reserved

Reserved

PRIOR

Non-reserved

Reserved

Reserved

PRIVATE

Non-reserved

-

-

PRIVILEGE

Non-reserved

-

-

PRIVILEGES

Non-reserved

Reserved

Reserved

PROCEDURAL

Non-reserved

-

-

PROCEDURE

Reserved

Reserved

Reserved

PROFILE

Non-reserved

-

-

PUBLIC

-

Reserved

Reserved

QUERY

Non-reserved

-

-

QUOTE

Non-reserved

-

-

RANDOMIZED

Non-reserved

-

  

RANGE

Non-reserved

-

-

RAW

Non-reserved

-

-

READ

Non-reserved

Reserved

Reserved

READS

-

Reserved

-

REAL

Non-reserved (excluding functions and types)

Reserved

Reserved

REASSIGN

Non-reserved

-

-

REBUILD

Non-reserved

-

-

RECHECK

Non-reserved

-

-

RECURSIVE

Non-reserved

Reserved

-

REF

Non-reserved

Reserved

-

REFERENCES

Reserved

Reserved

Reserved

REFERENCING

-

Reserved

-

REINDEX

Non-reserved

-

-

REJECT

Reserved

-

-

RELATIVE

Non-reserved

Reserved

Reserved

RELEASE

Non-reserved

-

-

RELOPTIONS

Non-reserved

-

-

REMOTE

Non-reserved

-

-

RENAME

Non-reserved

-

-

REPEATABLE

Non-reserved

Non-reserved

Non-reserved

REPLACE

Non-reserved

-

-

REPLICA

Non-reserved

-

-

RESET

Non-reserved

-

-

RESIZE

Non-reserved

-

-

RESOURCE

Non-reserved

-

-

RESTART

Non-reserved

-

-

RESTRICT

Non-reserved

Reserved

Reserved

RESULT

-

Reserved

-

RETURN

Non-reserved

Reserved

-

RETURNED_LENGTH

-

Non-reserved

Non-reserved

RETURNED_OCTET_LENGTH

-

Non-reserved

Non-reserved

RETURNED_SQLSTATE

-

Non-reserved

Non-reserved

RETURNING

Reserved

-

-

RETURNS

Non-reserved

Reserved

-

REUSE

Non-reserved

-

-

REVOKE

Non-reserved

Reserved

Reserved

RIGHT

Reserved (functions and types allowed)

Reserved

Reserved

ROLE

Non-reserved

Reserved

-

ROLLBACK

Non-reserved

Reserved

Reserved

ROLLUP

Non-reserved

Reserved

-

ROUTINE

-

Reserved

-

ROUTINE_CATALOG

-

Non-reserved

-

ROUTINE_NAME

-

Non-reserved

-

ROUTINE_SCHEMA

-

Non-reserved

-

ROW

Non-reserved (excluding functions and types)

Reserved

-

ROWS

Non-reserved

Reserved

Reserved

ROW_COUNT

-

Non-reserved

Non-reserved

RULE

Non-reserved

-

-

ROWNUM

Reserved

Reserved

-

SAVEPOINT

Non-reserved

Reserved

-

SCALE

-

Non-reserved

Non-reserved

SCHEMA

Non-reserved

Reserved

Reserved

SCHEMA_NAME

-

Non-reserved

Non-reserved

SCOPE

-

Reserved

-

SCROLL

Non-reserved

Reserved

Reserved

SEARCH

Non-reserved

Reserved

-

SECOND

Non-reserved

Reserved

Reserved

SECTION

-

Reserved

Reserved

SECURITY

Non-reserved

Non-reserved

-

SELECT

Reserved

Reserved

Reserved

SELF

-

Non-reserved

-

SENSITIVE

-

Non-reserved

-

SEQUENCE

Non-reserved

Reserved

-

SEQUENCES

Non-reserved

-

-

SERIALIZABLE

Non-reserved

Non-reserved

Non-reserved

SERVER

Non-reserved

-

-

SERVER_NAME

-

Non-reserved

Non-reserved

SESSION

Non-reserved

Reserved

Reserved

SESSION_USER

Reserved

Reserved

Reserved

SET

Non-reserved

Reserved

Reserved

SETOF

Non-reserved (excluding functions and types)

-

-

SETS

-

Reserved

-

SHARE

Non-reserved

-

-

SHIPPABLE

Non-reserved

-

-

SHOW

Non-reserved

-

-

SHUTDOWN

Non-reserved

-

-

SIMILAR

Reserved (functions and types allowed)

Non-reserved

-

SIMPLE

Non-reserved

Non-reserved

-

SIZE

Non-reserved

Reserved

Reserved

SMALLDATETIME_FORMAT

Non-reserved

-

-

SMALLDATETIME

Non-reserved (excluding functions and types)

-

-

SMALLINT

Non-reserved (excluding functions and types)

Reserved

Reserved

SNAPSHOT

Non-reserved

-

-

SOME

Reserved

Reserved

Reserved

SOURCE

Non-reserved

Non-reserved

-

SPACE

Non-reserved

Reserved

Reserved

SPECIFIC

-

Reserved

-

SPECIFICTYPE

-

Reserved

-

SPECIFIC_NAME

-

Non-reserved

-

SPILL

Non-reserved

-

-

SPLIT

Non-reserved

-

-

SQL

-

Reserved

Reserved

SQLCODE

-

-

Reserved

SQLERROR

-

-

Reserved

SQLEXCEPTION

-

Reserved

-

SQLSTATE

-

Reserved

Reserved

SQLWARNING

-

Reserved

-

STABLE

Non-reserved

-

-

STANDALONE

Non-reserved

-

-

START

Non-reserved

Reserved

-

STATE

-

Reserved

-

STATEMENT

Non-reserved

Reserved

-

STATEMENT_ID

Non-reserved

-

-

STATIC

-

Reserved

-

STATISTICS

Non-reserved

-

-

STDIN

Non-reserved

-

-

STDOUT

Non-reserved

-

-

STORAGE

Non-reserved

-

-

STORE

Non-reserved

-

-

STRICT

Non-reserved

-

-

STRIP

Non-reserved

-

-

STRUCTURE

-

Reserved

-

STYLE

-

Non-reserved

-

SUBCLASS_ORIGIN

-

Non-reserved

Non-reserved

SUBLIST

-

Non-reserved

-

SUBSTRING

Non-reserved (excluding functions and types)

Non-reserved

Reserved

SUM

-

Non-reserved

Reserved

SYMMETRIC

Reserved

Non-reserved

-

SYNONYM

Non-reserved

-

-

SYS_REFCURSOR

Non-reserved

-

-

SYSDATE

Reserved

-

-

SYSID

Non-reserved

-

-

SYSTEM

Non-reserved

Non-reserved

-

SYSTEM_USER

-

Reserved

Reserved

TABLE

Reserved

Reserved

Reserved

TABLES

Non-reserved

-

-

TABLE_NAME

-

Non-reserved

Non-reserved

TIME_FORMAT

Non-reserved

-

-

TIMESTAMP_FORMAT

Non-reserved

-

-

TEMP

Non-reserved

-

-

TEMPLATE

Non-reserved

-

-

TEMPORARY

Non-reserved

Reserved

Reserved

TERMINATE

-

Reserved

-

TEXT

Non-reserved

-

-

THAN

Non-reserved

Reserved

-

THEN

Reserved

Reserved

Reserved

TIME

Non-reserved (excluding functions and types)

Reserved

Reserved

TIMESTAMP

Non-reserved (excluding functions and types)

Reserved

Reserved

TIMESTAMPDIFF

Non-reserved (excluding functions and types)

-

-

TIMEZONE_HOUR

-

Reserved

Reserved

TIMEZONE_MINUTE

-

Reserved

Reserved

TINYINT

Non-reserved (excluding functions and types)

-

-

TO

Reserved

Reserved

Reserved

TRAILING

Reserved

Reserved

Reserved

TRANSACTION

Non-reserved

Reserved

Reserved

TRANSACTIONS_COMMITTED

-

Non-reserved

-

TRANSACTIONS_ROLLED_BACK

-

Non-reserved

-

TRANSACTION_ACTIVE

-

Non-reserved

-

TRANSFORM

-

Non-reserved

-

TRANSFORMS

-

Non-reserved

-

TRANSLATE

-

Non-reserved

Reserved

TRANSLATION

-

Reserved

Reserved

TREAT

Non-reserved (excluding functions and types)

Reserved

-

TRIGGER

Non-reserved

Reserved

-

TRIGGER_CATALOG

-

Non-reserved

-

TRIGGER_NAME

-

Non-reserved

-

TRIGGER_SCHEMA

-

Non-reserved

-

TRIM

Non-reserved (excluding functions and types)

Non-reserved

Reserved

TRUE

Reserved

Reserved

Reserved

TRUNCATE

Non-reserved

-

-

TRUSTED

Non-reserved

-

-

TSFIELD

Non-reserved

-

-

TSTAG

Non-reserved

-

-

TSTIME

Non-reserved

-

-

TYPE

Non-reserved

Non-reserved

Non-reserved

TYPES

Non-reserved

-

-

UESCAPE

-

-

-

UNBOUNDED

Non-reserved

-

-

UNCOMMITTED

Non-reserved

Non-reserved

Non-reserved

UNDER

-

Reserved

-

UNENCRYPTED

Non-reserved

-

-

UNION

Reserved

Reserved

Reserved

UNIQUE

Reserved

Reserved

Reserved

UNKNOWN

Non-reserved

Reserved

Reserved

UNLIMITED

Non-reserved

-

-

UNLISTEN

Non-reserved

-

-

UNLOCK

Non-reserved

-

-

UNLOGGED

Non-reserved

-

-

UNNAMED

-

Non-reserved

Non-reserved

UNNEST

-

Reserved

-

UNTIL

Non-reserved

-

-

UNUSABLE

Non-reserved

-

-

UPDATE

Non-reserved

Reserved

Reserved

UPPER

-

Non-reserved

Reserved

USAGE

-

Reserved

Reserved

USER

Reserved

Reserved

Reserved

USER_DEFINED_TYPE_CATALOG

-

Non-reserved

-

USER_DEFINED_TYPE_NAME

-

Non-reserved

-

USER_DEFINED_TYPE_SCHEMA

-

Non-reserved

-

USING

Reserved

Reserved

Reserved

VACUUM

Non-reserved

-

-

VALID

Non-reserved

-

-

VALIDATE

Non-reserved

-

-

VALIDATION

Non-reserved

-

-

VALIDATOR

Non-reserved

-

-

VALUE

Non-reserved

Reserved

Reserved

VALUES

Non-reserved (excluding functions and types)

Reserved

Reserved

VARCHAR

Non-reserved (excluding functions and types)

Reserved

Reserved

VARCHAR2

Non-reserved (excluding functions and types)

-

-

VARIABLE

-

Reserved

-

VARIADIC

Reserved

-

-

VARYING

Non-reserved

Reserved

Reserved

VCGROUP

Non-reserved

-

-

VERBOSE

Reserved (functions and types allowed)

-

-

VERSION

Non-reserved

-

-

VERIFY

Reserved

-

-

VIEW

Non-reserved

Reserved

Reserved

VOLATILE

Non-reserved

-

-

WHEN

Reserved

Reserved

Reserved

WHENEVER

-

Reserved

Reserved

WHERE

Reserved

Reserved

Reserved

WHITESPACE

Non-reserved

-

-

WINDOW

Reserved

-

-

WITH

Reserved

Reserved

Reserved

WITHIN

Non-reserved

-

-

WITHOUT

Non-reserved

Reserved

-

WORK

Non-reserved

Reserved

Reserved

WORKLOAD

Non-reserved

-

-

WRAPPER

Non-reserved

-

-

WRITE

Non-reserved

Reserved

Reserved

XML

Non-reserved

-

-

XMLATTRIBUTES

Non-reserved (excluding functions and types)

-

-

XMLCONCAT

Non-reserved (excluding functions and types)

-

-

XMLELEMENT

Non-reserved (excluding functions and types)

-

-

XMLEXISTS

Non-reserved (excluding functions and types)

-

-

XMLFOREST

Non-reserved (excluding functions and types)

-

-

XMLPARSE

Non-reserved (excluding functions and types)

-

-

XMLPI

Non-reserved (excluding functions and types)

-

-

XMLROOT

Non-reserved (excluding functions and types)

-

-

XMLSERIALIZE

Non-reserved (excluding functions and types)

-

-

YEAR

Non-reserved

Reserved

Reserved

YES

Non-reserved

-

-

ZONE

Non-reserved

Reserved

Reserved

Feedback
编组 3备份
    openGauss 2024-05-06 00:44:54
    cancel