Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive
On this page

Show all

Keyword

Updated on 2022-07-29 GMT+08:00

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.

Table 1 SQL keywords

Keyword

GaussDB(DWS)

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

-

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

-

-

AUTHINFO

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

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

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

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

COLUMNS

Non-reserved

-

-

COLUMN_NAME

-

Non-reserved

Non-reserved

COMMAND_FUNCTION

-

Non-reserved

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

COMPATIBLE_ILLEGAL_CHARS

Non-reserved

-

-

COMPLETE

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

-

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

DATE_FORMAT

Non-reserved

-

-

DATABASE

Non-reserved

-

-

DATAFILE

Non-reserved

-

-

DATE

Non-reserved (excluding functions and types)

Reserved

Reserved

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

-

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

DYNAMIC

-

Reserved

-

DYNAMIC_FUNCTION

-

Non-reserved

Non-reserved

DYNAMIC_FUNCTION_CODE

-

Non-reserved

-

EACH

Non-reserved

Reserved

-

ELASTIC

Non-reserved

-

-

ELSE

Reserved

Reserved

Reserved

ENABLE

Non-reserved

-

-

ENCODING

Non-reserved

-

-

ENCRYPTED

Non-reserved

-

-

END

Reserved

Reserved

Reserved

END-EXEC

-

Reserved

Reserved

ENFORCED

Non-reserved

-

-

ENUM

Non-reserved

-

-

EOL

Non-reserved

-

-

EQUALS

-

Reserved

-

ERRORS

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

-

-

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

EXPIRATION

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

-

-

FENCED

Non-reserved

-

-

FETCH

Reserved

Reserved

Reserved

FILEHEADER

Non-reserved

-

-

FILL_MISSING_FIELDS

Non-reserved

-

-

FINAL

-

Non-reserved

-

FIRST

Non-reserved

Reserved

Reserved

FIXED

Non-reserved

Reserved

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

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

-

Reserved

-

HANDLER

Non-reserved

-

-

HAVING

Reserved

Reserved

Reserved

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 (excluding functions and types)

-

-

IFNULL

Non-reserved (excluding functions and types)

-

-

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

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

INTERNAL

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 (excluding functions and types)

-

-

ISOLATION

Non-reserved

Reserved

Reserved

ITERATE

-

Reserved

-

JOIN

Reserved (functions and types allowed)

Reserved

Reserved

K

-

Non-reserved

-

KEY

Non-reserved

Reserved

Reserved

KEY_MEMBER

-

Non-reserved

-

KEY_TYPE

-

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

-

-

LOGIN

Non-reserved

-

-

LOOP

Non-reserved

-

-

LOWER

-

Non-reserved

Reserved

M

-

Non-reserved

-

MAP

-

Reserved

-

MAPPING

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

-

-

NOLOGIN

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

Reserved

-

-

PLANS

Non-reserved

-

-

PLI

-

Non-reserved

Non-reserved

POLICY

Non-reserved

-

-

POOL

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

-

-

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

-

REFRESH

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

-

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

-

-

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

-

-

SIMILAR

Reserved (functions and types allowed)

Non-reserved

-

SIMPLE

Non-reserved

Non-reserved

-

SIZE

Non-reserved

Reserved

Reserved

SMALLDATETIME

Non-reserved (excluding functions and types)

-

-

SMALLDATETIME_FORMAT

Non-reserved

-

-

SMALLINT

Non-reserved (excluding functions and types)

Reserved

Reserved

SNAPSHOT

Non-reserved

-

-

SOME

Reserved

Reserved

Reserved

SOURCE

Non-reserved

Non-reserved

-

SPACE

-

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

SUPERUSER

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

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

TIME_FORMAT

Non-reserved

-

-

TIMESTAMP

Non-reserved (excluding functions and types)

Reserved

Reserved

TIMESTAMPDIFF

Non-reserved (excluding functions and types)

-

-

TIMESTAMP_FORMAT

Non-reserved

-

-

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

-

-

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)

-

-

VERIFY

Non-reserved

-

-

VERSION

Non-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)

-

-

XMLNAMESPACES

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)

-

-

XMLTABLE

Non-reserved (excluding functions and types)

-

-

YEAR

Non-reserved

Reserved

Reserved

YES

Non-reserved

-

-

ZONE

Non-reserved

Reserved

Reserved

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback