介绍

为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字，接下来会列出mysql、oracle、sqlserver三个数据库各自的保留关键字。

Mysql

ACCESSIBLE (R)

ACCOUNT[a]

ACTION

ADD (R)

AFTER

AGAINST

AGGREGATE

ALGORITHM

ALL (R)

ALTER (R)

ALWAYS[b]

ANALYSE

ANALYZE (R)

AND (R)

ANY

AS (R)

ASC (R)

ASCII

ASENSITIVE (R)

AT

AUTOEXTEND_SIZE

AUTO_INCREMENT

AVG

AVG_ROW_LENGTH

BACKUP

BEFORE (R)

BEGIN

BETWEEN (R)

BIGINT (R)

BINARY (R)

BINLOG

BIT

BLOB (R)

BLOCK

BOOL

BOOLEAN

BOTH (R)

BTREE

BY (R)

BYTE

CACHE

CALL (R)

CASCADE (R)

CASCADED

CASE (R)

CATALOG_NAME

CHAIN

CHANGE (R)

CHANGED

CHANNEL[c]

CHAR (R)

CHARACTER (R)

CHARSET

CHECK (R)

CHECKSUM

CIPHER

CLASS_ORIGIN

CLIENT

CLOSE

COALESCE

CODE

COLLATE (R)

COLLATION

COLUMN (R)

COLUMNS

COLUMN_FORMAT

COLUMN_NAME

COMMENT

COMMIT

COMMITTED

COMPACT

COMPLETION

COMPRESSED

COMPRESSION[d]

CONCURRENT

CONDITION (R)

CONNECTION

CONSISTENT

CONSTRAINT (R)

CONSTRAINT_CATALOG

CONSTRAINT_NAME

CONSTRAINT_SCHEMA

CONTAINS

CONTEXT

CONTINUE (R)

CONVERT (R)

CPU

CREATE (R)

CROSS (R)

CUBE

CURRENT

CURRENT_DATE (R)

CURRENT_TIME (R)

CURRENT_TIMESTAMP (R)

CURRENT_USER (R)

CURSOR (R)

CURSOR_NAME

DATA

DATABASE (R)

DATABASES (R)

DATAFILE

DATE

DATETIME

DAY

DAY_HOUR (R)

DAY_MICROSECOND (R)

DAY_MINUTE (R)

DAY_SECOND (R)

DEALLOCATE

DEC (R)

DECIMAL (R)

DECLARE (R)

DEFAULT (R)

DEFAULT_AUTH

DEFINER

DELAYED (R)

DELAY_KEY_WRITE

DELETE (R)

DESC (R)

DESCRIBE (R)

DES_KEY_FILE

DETERMINISTIC (R)

DIAGNOSTICS

DIRECTORY

DISABLE

DISCARD

DISK

DISTINCT (R)

DISTINCTROW (R)

DIV (R)

DO

DOUBLE (R)

DROP (R)

DUAL (R)

DUMPFILE

DUPLICATE

DYNAMIC

EACH (R)

ELSE (R)

ELSEIF (R)

ENABLE

ENCLOSED (R)

ENCRYPTION[e]

END

ENDS

ENGINE

ENGINES

ENUM

ERROR

ERRORS

ESCAPE

ESCAPED (R)

EVENT

EVENTS

EVERY

EXCHANGE

EXECUTE

EXISTS (R)

EXIT (R)

EXPANSION

EXPIRE

EXPLAIN (R)

EXPORT

EXTENDED

EXTENT_SIZE

FALSE (R)

FAST

FAULTS

FETCH (R)

FIELDS

FILE

FILE_BLOCK_SIZE[f]

FILTER[g]

FIRST

FIXED

FLOAT (R)

FLOAT4 (R)

FLOAT8 (R)

FLUSH

FOLLOWS[h]

FOR (R)

FORCE (R)

FOREIGN (R)

FORMAT

FOUND

FROM (R)

FULL

FULLTEXT (R)

FUNCTION

GENERAL

GENERATED[i] (R)

GEOMETRY

GEOMETRYCOLLECTION

GET (R)

GET_FORMAT

GLOBAL

GRANT (R)

GRANTS

GROUP (R)

GROUP_REPLICATION[j]

HANDLER

HASH

HAVING (R)

HELP

HIGH_PRIORITY (R)

HOST

HOSTS

HOUR

HOUR_MICROSECOND (R)

HOUR_MINUTE (R)

HOUR_SECOND (R)

IDENTIFIED

IF (R)

IGNORE (R)

IGNORE_SERVER_IDS

IMPORT

IN (R)

INDEX (R)

INDEXES

INFILE (R)

INITIAL_SIZE

INNER (R)

INOUT (R)

INSENSITIVE (R)

INSERT (R)

INSERT_METHOD

INSTALL

INSTANCE[k]

INT (R)

INT1 (R)

INT2 (R)

INT3 (R)

INT4 (R)

INT8 (R)

INTEGER (R)

INTERVAL (R)

INTO (R)

INVOKER

IO

IO_AFTER_GTIDS (R)

IO_BEFORE_GTIDS (R)

IO_THREAD

IPC

IS (R)

ISOLATION

ISSUER

ITERATE (R)

JOIN (R)

JSON[l]

KEY (R)

KEYS (R)

KEY_BLOCK_SIZE

KILL (R)

LANGUAGE

LAST

LEADING (R)

LEAVE (R)

LEAVES

LEFT (R)

LESS

LEVEL

LIKE (R)

LIMIT (R)

LINEAR (R)

LINES (R)

LINESTRING

LIST

LOAD (R)

LOCAL

LOCALTIME (R)

LOCALTIMESTAMP (R)

LOCK (R)

LOCKS

LOGFILE

LOGS

LONG (R)

LONGBLOB (R)

LONGTEXT (R)

LOOP (R)

LOW_PRIORITY (R)

MASTER

MASTER_AUTO_POSITION

MASTER_BIND (R)

MASTER_CONNECT_RETRY

MASTER_DELAY

MASTER_HEARTBEAT_PERIOD

MASTER_HOST

MASTER_LOG_FILE

MASTER_LOG_POS

MASTER_PASSWORD

MASTER_PORT

MASTER_RETRY_COUNT

MASTER_SERVER_ID

MASTER_SSL

MASTER_SSL_CA

MASTER_SSL_CAPATH

MASTER_SSL_CERT

MASTER_SSL_CIPHER

MASTER_SSL_CRL

MASTER_SSL_CRLPATH

MASTER_SSL_KEY

MASTER_SSL_VERIFY_SERVER_CERT (R)

MASTER_TLS_VERSION[m]

MASTER_USER

MATCH (R)

MAXVALUE (R)

MAX_CONNECTIONS_PER_HOUR

MAX_QUERIES_PER_HOUR

MAX_ROWS

MAX_SIZE

MAX_STATEMENT_TIME[n]

MAX_UPDATES_PER_HOUR

MAX_USER_CONNECTIONS

MEDIUM

MEDIUMBLOB (R)

MEDIUMINT (R)

MEDIUMTEXT (R)

MEMORY

MERGE

MESSAGE_TEXT

MICROSECOND

MIDDLEINT (R)

MIGRATE

MINUTE

MINUTE_MICROSECOND (R)

MINUTE_SECOND (R)

MIN_ROWS

MOD (R)

MODE

MODIFIES (R)

MODIFY

MONTH

MULTILINESTRING

MULTIPOINT

MULTIPOLYGON

MUTEX

MYSQL_ERRNO

NAME

NAMES

NATIONAL

NATURAL (R)

NCHAR

NDB

NDBCLUSTER

NEVER[o]

NEW

NEXT

NO

NODEGROUP

NONBLOCKING[p]

NONE

NOT (R)

NO_WAIT

NO_WRITE_TO_BINLOG (R)

NULL (R)

NUMBER

NUMERIC (R)

NVARCHAR

OFFSET

OLD_PASSWORD[q]

ON (R)

ONE

ONLY

OPEN

OPTIMIZE (R)

OPTIMIZER_COSTS[r] (R)

OPTION (R)

OPTIONALLY (R)

OPTIONS

OR (R)

ORDER (R)

OUT (R)

OUTER (R)

OUTFILE (R)

OWNER

PACK_KEYS

PAGE

PARSER

PARSE_GCOL_EXPR[s]

PARTIAL

PARTITION (R)

PARTITIONING

PARTITIONS

PASSWORD

PHASE

PLUGIN

PLUGINS

PLUGIN_DIR

POINT

POLYGON

PORT

PRECEDES[t]

PRECISION (R)

PREPARE

PRESERVE

PREV

PRIMARY (R)

PRIVILEGES

PROCEDURE (R)

PROCESSLIST

PROFILE

PROFILES

PROXY

PURGE (R)

QUARTER

QUERY

QUICK

RANGE (R)

READ (R)

READS (R)

READ_ONLY

READ_WRITE (R)

REAL (R)

REBUILD

RECOVER

REDOFILE

REDO_BUFFER_SIZE

REDUNDANT

REFERENCES (R)

REGEXP (R)

RELAY

RELAYLOG

RELAY_LOG_FILE

RELAY_LOG_POS

RELAY_THREAD

RELEASE (R)

RELOAD

REMOVE

RENAME (R)

REORGANIZE

REPAIR

REPEAT (R)

REPEATABLE

REPLACE (R)

REPLICATE_DO_DB[u]

REPLICATE_DO_TABLE[v]

REPLICATE_IGNORE_DB[w]

REPLICATE_IGNORE_TABLE[x]

REPLICATE_REWRITE_DB[y]

REPLICATE_WILD_DO_TABLE[z]

REPLICATE_WILD_IGNORE_TABLE[aa]

REPLICATION

REQUIRE (R)

RESET

RESIGNAL (R)

RESTORE

RESTRICT (R)

RESUME

RETURN (R)

RETURNED_SQLSTATE

RETURNS

REVERSE

REVOKE (R)

RIGHT (R)

RLIKE (R)

ROLLBACK

ROLLUP

ROTATE[ab]

ROUTINE

ROW

ROWS

ROW_COUNT

ROW_FORMAT

RTREE

SAVEPOINT

SCHEDULE

SCHEMA (R)

SCHEMAS (R)

SCHEMA_NAME

SECOND

SECOND_MICROSECOND (R)

SECURITY

SELECT (R)

SENSITIVE (R)

SEPARATOR (R)

SERIAL

SERIALIZABLE

SERVER

SESSION

SET (R)

SHARE

SHOW (R)

SHUTDOWN

SIGNAL (R)

SIGNED

SIMPLE

SLAVE

SLOW

SMALLINT (R)

SNAPSHOT

SOCKET

SOME

SONAME

SOUNDS

SOURCE

SPATIAL (R)

SPECIFIC (R)

SQL (R)

SQLEXCEPTION (R)

SQLSTATE (R)

SQLWARNING (R)

SQL_AFTER_GTIDS

SQL_AFTER_MTS_GAPS

SQL_BEFORE_GTIDS

SQL_BIG_RESULT (R)

SQL_BUFFER_RESULT

SQL_CACHE

SQL_CALC_FOUND_ROWS (R)

SQL_NO_CACHE

SQL_SMALL_RESULT (R)

SQL_THREAD

SQL_TSI_DAY

SQL_TSI_HOUR

SQL_TSI_MINUTE

SQL_TSI_MONTH

SQL_TSI_QUARTER

SQL_TSI_SECOND

SQL_TSI_WEEK

SQL_TSI_YEAR

SSL (R)

STACKED

START

STARTING (R)

STARTS

STATS_AUTO_RECALC

STATS_PERSISTENT

STATS_SAMPLE_PAGES

STATUS

STOP

STORAGE

STORED[ac] (R)

STRAIGHT_JOIN (R)

STRING

SUBCLASS_ORIGIN

SUBJECT

SUBPARTITION

SUBPARTITIONS

SUPER

SUSPEND

SWAPS

SWITCHES

TABLE (R)

TABLES

TABLESPACE

TABLE_CHECKSUM

TABLE_NAME

TEMPORARY

TEMPTABLE

TERMINATED (R)

TEXT

THAN

THEN (R)

TIME

TIMESTAMP

TIMESTAMPADD

TIMESTAMPDIFF

TINYBLOB (R)

TINYINT (R)

TINYTEXT (R)

TO (R)

TRAILING (R)

TRANSACTION

TRIGGER (R)

TRIGGERS

TRUE (R)

TRUNCATE

TYPE

TYPES

UNCOMMITTED

UNDEFINED

UNDO (R)

UNDOFILE

UNDO_BUFFER_SIZE

UNICODE

UNINSTALL

UNION (R)

UNIQUE (R)

UNKNOWN

UNLOCK (R)

UNSIGNED (R)

UNTIL

UPDATE (R)

UPGRADE

USAGE (R)

USE (R)

USER

USER_RESOURCES

USE_FRM

USING (R)

UTC_DATE (R)

UTC_TIME (R)

UTC_TIMESTAMP (R)

VALIDATION[ad]

VALUE

VALUES (R)

VARBINARY (R)

VARCHAR (R)

VARCHARACTER (R)

VARIABLES

VARYING (R)

VIEW

VIRTUAL[ae] (R)

WAIT

WARNINGS

WEEK

WEIGHT_STRING

WHEN (R)

WHERE (R)

WHILE (R)

WITH (R)

WITHOUT[af]

WORK

WRAPPER

WRITE (R)

X509

XA

XML

XOR (R)

YEAR

YEAR_MONTH (R)

ZEROFILL (R)

Oracle

select* fromv$reserved_words orderbykeyword asc

!

!=

&

(

)

*

+

,

-

.

/

:

;

<

<<

<=

=

=>

>

>=

@

A

ABORT

ABS

ACCESS

ACCESSED

ACCOUNT

ACOS

ACTIVATE

ACTIVE_COMPONENT

ACTIVE_FUNCTION

ACTIVE_TAG

ADD

ADD_COLUMN

ADD_GROUP

ADD_MONTHS

ADJ_DATE

ADMIN

ADMINISTER

ADMINISTRATOR

ADVISE

ADVISOR

AFTER

ALIAS

ALL

ALLOCATE

ALLOW

ALL_ROWS

ALTER

ALWAYS

ANALYZE

ANCILLARY

AND

AND_EQUAL

ANTIJOIN

ANY

ANYSCHEMA

APPEND

APPENDCHILDXML

APPEND_VALUES

APPLY

ARCHIVE

ARCHIVELOG

ARRAY

AS

ASC

ASCII

ASCIISTR

ASIN

ASSEMBLY

ASSOCIATE

ASYNC

ASYNCHRONOUS

AT

ATAN

ATAN2

ATTRIBUTE

ATTRIBUTES

AUDIT

AUTHENTICATED

AUTHENTICATION

AUTHID

AUTHORIZATION

AUTO

AUTOALLOCATE

AUTOEXTEND

AUTOMATIC

AVAILABILITY

AVG

BACKUP

BASIC

BASICFILE

BATCH

BECOME

BEFORE

BEGIN

BEGIN_OUTLINE_DATA

BEHALF

BETWEEN

BFILE

BFILENAME

BIGFILE

BINARY

BINARY_DOUBLE

BINARY_DOUBLE_INFINITY

BINARY_DOUBLE_NAN

BINARY_FLOAT

BINARY_FLOAT_INFINITY

BINARY_FLOAT_NAN

BINDING

BIND_AWARE

BIN_TO_NUM

BITAND

BITMAP

BITMAPS

BITMAP_TREE

BITS

BLOB

BLOCK

BLOCKS

BLOCKSIZE

BLOCK_RANGE

BODY

BOTH

BOUND

BRANCH

BREADTH

BROADCAST

BUFFER

BUFFER_CACHE

BUFFER_POOL

BUILD

BULK

BY

BYPASS_RECURSIVE_CHECK

BYPASS_UJVC

BYTE

CACHE

CACHE_CB

CACHE_INSTANCES

CACHE_TEMP_TABLE

CALL

CANCEL

CARDINALITY

CASCADE

CASE

CAST

CATEGORY

CEIL

CELL_FLASH_CACHE

CERTIFICATE

CFILE

CHAINED

CHANGE

CHANGE_DUPKEY_ERROR_INDEX

CHAR

CHARACTER

CHARTOROWID

CHAR_CS

CHECK

CHECKPOINT

CHECK_ACL_REWRITE

CHILD

CHOOSE

CHR

CHUNK

CLASS

CLEAR

CLOB

CLONE

CLOSE

CLOSE_CACHED_OPEN_CURSORS

CLUSTER

CLUSTERING_FACTOR

CLUSTER_ID

CLUSTER_PROBABILITY

CLUSTER_SET

COALESCE

COALESCE_SQ

COARSE

COLD

COLLECT

COLUMN

COLUMNAR

COLUMNS

COLUMN_AUTH_INDICATOR

COLUMN_STATS

COLUMN_VALUE

COMMENT

COMMIT

COMMITTED

COMPACT

COMPATIBILITY

COMPILE

COMPLETE

COMPLIANCE

COMPOSE

COMPOSITE

COMPOSITE_LIMIT

COMPOUND

COMPRESS

COMPUTE

CONCAT

CONFIRM

CONFORMING

CONNECT

CONNECT_BY_CB_WHR_ONLY

CONNECT_BY_COMBINE_SW

CONNECT_BY_COST_BASED

CONNECT_BY_ELIM_DUPS

CONNECT_BY_FILTERING

CONNECT_BY_ISCYCLE

CONNECT_BY_ISLEAF

CONNECT_BY_ROOT

CONNECT_TIME

CONSIDER

CONSISTENT

CONST

CONSTANT

CONSTRAINT

CONSTRAINTS

CONTAINER

CONTENT

CONTENTS

CONTEXT

CONTINUE

CONTROLFILE

CONVERT

CORR

CORRUPTION

CORRUPT_XID

CORRUPT_XID_ALL

CORR_K

CORR_S

COS

COSH

COST

COST_XML_QUERY_REWRITE

COUNT

COVAR_POP

COVAR_SAMP

CO_AUTH_IND

CPU_COSTING

CPU_PER_CALL

CPU_PER_SESSION

CRASH

CREATE

CREATE_STORED_OUTLINES

CREATION

CROSS

CROSSEDITION

CSCONVERT

CUBE

CUBE_GB

CUME_DIST

CUME_DISTM

CURRENT

CURRENTV

CURRENT_DATE

CURRENT_SCHEMA

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

CURSOR_SHARING_EXACT

CURSOR_SPECIFIC_SEGMENT

CV

CYCLE

D

DANGLING

DATA

DATABASE

DATABASE_DEFAULT

DATAFILE

DATAFILES

DATAOBJNO

DATAOBJ_TO_PARTITION

DATE

DATE_MODE

DAY

DBA

DBA_RECYCLEBIN

DBMS_STATS

DBTIMEZONE

DB_ROLE_CHANGE

DB_VERSION

DDL

DEALLOCATE

DEBUG

DEBUGGER

DEC

DECIMAL

DECLARE

DECODE

DECOMPOSE

DECR

DECREMENT

DECRYPT

DEDUPLICATE

DEFAULT

DEFAULTS

DEFERRABLE

DEFERRED

DEFINED

DEFINER

DEGREE

DELAY

DELETE

DELETEXML

DEMAND

DENSE_RANK

DENSE_RANKM

DEPENDENT

DEPTH

DEQUEUE

DEREF

DEREF_NO_REWRITE

DESC

DETACHED

DETERMINES

DICTIONARY

DIMENSION

DIRECTORY

DIRECT_LOAD

DISABLE

DISABLE_PRESET

DISABLE_RPKE

DISALLOW

DISASSOCIATE

DISCONNECT

DISK

DISKGROUP

DISKS

DISMOUNT

DISTINCT

DISTINGUISHED

DISTRIBUTED

DML

DML_UPDATE

DOCFIDELITY

DOCUMENT

DOMAIN_INDEX_FILTER

DOMAIN_INDEX_NO_SORT

DOMAIN_INDEX_SORT

DOUBLE

DOWNGRADE

DRIVING_SITE

DROP

DROP_COLUMN

DROP_GROUP

DST_UPGRADE_INSERT_CONV

DUMP

DYNAMIC

DYNAMIC_SAMPLING

DYNAMIC_SAMPLING_EST_CDN

E

EACH

EDITION

EDITIONING

EDITIONS

ELEMENT

ELIMINATE_JOIN

ELIMINATE_OBY

ELIMINATE_OUTER_JOIN

ELSE

EMPTY

EMPTY_BLOB

EMPTY_CLOB

ENABLE

ENABLE_PRESET

ENCODING

ENCRYPT

ENCRYPTION

END

END_OUTLINE_DATA

ENFORCE

ENFORCED

ENQUEUE

ENTERPRISE

ENTITYESCAPING

ENTRY

ERROR

ERRORS

ERROR_ARGUMENT

ERROR_ON_OVERLAP_TIME

ESCAPE

ESTIMATE

EVALNAME

EVALUATION

EVENTS

EVERY

EXCEPT

EXCEPTIONS

EXCHANGE

EXCLUDE

EXCLUDING

EXCLUSIVE

EXECUTE

EXEMPT

EXISTS

EXISTSNODE

EXP

EXPAND_GSET_TO_UNION

EXPAND_TABLE

EXPIRE

EXPLAIN

EXPLOSION

EXPORT

EXPR_CORR_CHECK

EXTENDS

EXTENT

EXTENTS

EXTERNAL

EXTERNALLY

EXTRA

EXTRACT

EXTRACTVALUE

FACILITY

FACT

FACTORIZE_JOIN

FAILED

FAILED_LOGIN_ATTEMPTS

FAILGROUP

FALSE

FAST

FBTSCAN

FEATURE_ID

FEATURE_SET

FEATURE_VALUE

FILE

FILESYSTEM_LIKE_LOGGING

FILTER

FINAL

FINE

FINISH

FIRST

FIRSTM

FIRST_ROWS

FIRST_VALUE

FLAGGER

FLASHBACK

FLASH_CACHE

FLOAT

FLOB

FLOOR

FLUSH

FOLDER

FOLLOWING

FOLLOWS

FOR

FORCE

FORCE_XML_QUERY_REWRITE

FOREIGN

FOREVER

FORWARD

FREELIST

FREELISTS

FREEPOOLS

FRESH

FROM

FROM_TZ

FULL

FUNCTION

FUNCTIONS

G

GATHER_PLAN_STATISTICS

GBY_CONC_ROLLUP

GBY_PUSHDOWN

GENERATED

GLOBAL

GLOBALLY

GLOBAL_NAME

GLOBAL_TOPIC_ENABLED

GRANT

GREATEST

GROUP

GROUPING

GROUPING_ID

GROUPS

GROUP_BY

GROUP_ID

GUARANTEE

GUARANTEED

GUARD

H

HASH

HASHKEYS

HASH_AJ

HASH_SJ

HAVING

HEADER

HEAP

HELP

HEXTORAW

HEXTOREF

HIDDEN

HIDE

HIERARCHY

HIGH

HINTSET_BEGIN

HINTSET_END

HOT

HOUR

HWM_BROKERED

HYBRID

ID

IDENTIFIED

IDENTIFIER

IDENTITY

IDGENERATORS

IDLE_TIME

IF

IGNORE

IGNORE_OPTIM_EMBEDDED_HINTS

IGNORE_ROW_ON_DUPKEY_INDEX

IGNORE_WHERE_CLAUSE

IMMEDIATE

IMPACT

IMPORT

IN

INCLUDE

INCLUDE_VERSION

INCLUDING

INCR

INCREMENT

INCREMENTAL

INDENT

INDEX

INDEXED

INDEXES

INDEXTYPE

INDEXTYPES

INDEX_ASC

INDEX_COMBINE

INDEX_DESC

INDEX_FFS

INDEX_FILTER

INDEX_JOIN

INDEX_ROWS

INDEX_RRS

INDEX_RS

INDEX_RS_ASC

INDEX_RS_DESC

INDEX_SCAN

INDEX_SKIP_SCAN

INDEX_SS

INDEX_SS_ASC

INDEX_SS_DESC

INDEX_STATS

INDICATOR

INFINITE

INFORMATIONAL

INITCAP

INITIAL

INITIALIZED

INITIALLY

INITRANS

INLINE

INLINE_XMLTYPE_NT

INNER

INSERT

INSERTCHILDXML

INSERTCHILDXMLAFTER

INSERTCHILDXMLBEFORE

INSERTXMLAFTER

INSERTXMLBEFORE

INSTANCE

INSTANCES

INSTANTIABLE

INSTANTLY

INSTEAD

INSTR

INSTR2

INSTR4

INSTRB

INSTRC

INT

INTEGER

INTERMEDIATE

INTERNAL_CONVERT

INTERNAL_USE

INTERPRETED

INTERSECT

INTERVAL

INTO

INVALIDATE

INVISIBLE

IN_MEMORY_METADATA

IN_XQUERY

IS

ISOLATION

ISOLATION_LEVEL

ITERATE

ITERATION_NUMBER

JAVA

JOB

JOIN

K

KEEP

KEEP_DUPLICATES

KERBEROS

KEY

KEYS

KEYSIZE

KEY_LENGTH

KILL

LAG

LAST

LAST_DAY

LAST_VALUE

LATERAL

LAYER

LDAP_REGISTRATION

LDAP_REGISTRATION_ENABLED

LDAP_REG_SYNC_INTERVAL

LEAD

LEADING

LEAST

LEFT

LENGTH

LENGTH2

LENGTH4

LENGTHB

LENGTHC

LESS

LEVEL

LEVELS

LIBRARY

LIFE

LIFETIME

LIKE

LIKE2

LIKE4

LIKEC

LIKE_EXPAND

LIMIT

LINK

LIST

LISTAGG

LN

LNNVL

LOB

LOBNVL

LOBS

LOCAL

LOCALTIME

LOCALTIMESTAMP

LOCAL_INDEXES

LOCATION

LOCATOR

LOCK

LOCKED

LOG

LOGFILE

LOGFILES

LOGGING

LOGICAL

LOGICAL_READS_PER_CALL

LOGICAL_READS_PER_SESSION

LOGOFF

LOGON

LONG

LOW

LOWER

LPAD

LTRIM

M

MAIN

MAKE_REF

MANAGE

MANAGED

MANAGEMENT

MANUAL

MAPPING

MASTER

MATCHED

MATERIALIZE

MATERIALIZED

MAX

MAXARCHLOGS

MAXDATAFILES

MAXEXTENTS

MAXIMIZE

MAXINSTANCES

MAXLOGFILES

MAXLOGHISTORY

MAXLOGMEMBERS

MAXSIZE

MAXTRANS

MAXVALUE

MEASURE

MEASURES

MEDIAN

MEDIUM

MEMBER

MEMORY

MERGE

MERGE$ACTIONS

MERGE_AJ

MERGE_CONST_ON

MERGE_SJ

METHOD

MIGRATE

MIGRATION

MIN

MINEXTENTS

MINIMIZE

MINIMUM

MINING

MINUS

MINUS_NULL

MINUTE

MINVALUE

MIRROR

MIRRORCOLD

MIRRORHOT

MLSLABEL

MOD

MODE

MODEL

MODEL_COMPILE_SUBQUERY

MODEL_DONTVERIFY_UNIQUENESS

MODEL_DYNAMIC_SUBQUERY

MODEL_MIN_ANALYSIS

MODEL_NO_ANALYSIS

MODEL_PBY

MODEL_PUSH_REF

MODIFY

MONITOR

MONITORING

MONTH

MONTHS_BETWEEN

MOUNT

MOUNTPATH

MOVE

MOVEMENT

MULTISET

MV_MERGE

NAME

NAMED

NAMESPACE

NAN

NANVL

NATIONAL

NATIVE

NATIVE_FULL_OUTER_JOIN

NATURAL

NAV

NCHAR

NCHAR_CS

NCHR

NCLOB

NEEDED

NESTED

NESTED_TABLE_FAST_INSERT

NESTED_TABLE_GET_REFS

NESTED_TABLE_ID

NESTED_TABLE_SET_REFS

NESTED_TABLE_SET_SETID

NETWORK

NEVER

NEW

NEW_TIME

NEXT

NEXT_DAY

NLJ_BATCHING

NLJ_INDEX_FILTER

NLJ_INDEX_SCAN

NLJ_PREFETCH

NLSSORT

NLS_CALENDAR

NLS_CHARACTERSET

NLS_CHARSET_DECL_LEN

NLS_CHARSET_ID

NLS_CHARSET_NAME

NLS_COMP

NLS_CURRENCY

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_INITCAP

NLS_ISO_CURRENCY

NLS_LANG

NLS_LANGUAGE

NLS_LENGTH_SEMANTICS

NLS_LOWER

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

NLS_SORT

NLS_SPECIAL_CHARS

NLS_TERRITORY

NLS_UPPER

NL_AJ

NL_SJ

NO

NOAPPEND

NOARCHIVELOG

NOAUDIT

NOCACHE

NOCOMPRESS

NOCPU_COSTING

NOCYCLE

NODELAY

NOENTITYESCAPING

NOFORCE

NOGUARANTEE

NOLOCAL

NOLOGGING

NOMAPPING

NOMAXVALUE

NOMINIMIZE

NOMINVALUE

NOMONITORING

NONE

NONSCHEMA

NOORDER

NOOVERRIDE

NOPARALLEL

NOPARALLEL_INDEX

NORELY

NOREPAIR

NORESETLOGS

NOREVERSE

NOREWRITE

NORMAL

NOROWDEPENDENCIES

NOSCHEMACHECK

NOSEGMENT

NOSORT

NOSTRICT

NOSWITCH

NOT

NOTHING

NOTIFICATION

NOVALIDATE

NOWAIT

NO_ACCESS

NO_BASETABLE_MULTIMV_REWRITE

NO_BIND_AWARE

NO_BUFFER

NO_CARTESIAN

NO_CHECK_ACL_REWRITE

NO_COALESCE_SQ

NO_CONNECT_BY_CB_WHR_ONLY

NO_CONNECT_BY_COMBINE_SW

NO_CONNECT_BY_COST_BASED

NO_CONNECT_BY_ELIM_DUPS

NO_CONNECT_BY_FILTERING

NO_COST_XML_QUERY_REWRITE

NO_CPU_COSTING

NO_DOMAIN_INDEX_FILTER

NO_DST_UPGRADE_INSERT_CONV

NO_ELIMINATE_JOIN

NO_ELIMINATE_OBY

NO_ELIMINATE_OUTER_JOIN

NO_EXPAND

NO_EXPAND_GSET_TO_UNION

NO_EXPAND_TABLE

NO_FACT

NO_FACTORIZE_JOIN

NO_FILTERING

NO_GBY_PUSHDOWN

NO_INDEX

NO_INDEX_FFS

NO_INDEX_SS

NO_LOAD

NO_MERGE

NO_MODEL_PUSH_REF

NO_MONITOR

NO_MONITORING

NO_MULTIMV_REWRITE

NO_NATIVE_FULL_OUTER_JOIN

NO_NLJ_BATCHING

NO_NLJ_PREFETCH

NO_ORDER_ROLLUPS

NO_OUTER_JOIN_TO_INNER

NO_PARALLEL

NO_PARALLEL_INDEX

NO_PARTIAL_COMMIT

NO_PLACE_DISTINCT

NO_PLACE_GROUP_BY

NO_PQ_MAP

NO_PRUNE_GSETS

NO_PULL_PRED

NO_PUSH_PRED

NO_PUSH_SUBQ

NO_PX_JOIN_FILTER

NO_QKN_BUFF

NO_QUERY_TRANSFORMATION

NO_REF_CASCADE

NO_RESULT_CACHE

NO_REWRITE

NO_SEMIJOIN

NO_SET_TO_JOIN

NO_SQL_TUNE

NO_STAR_TRANSFORMATION

NO_STATEMENT_QUEUING

NO_STATS_GSETS

NO_SUBQUERY_PRUNING

NO_SUBSTRB_PAD

NO_SWAP_JOIN_INPUTS

NO_TEMP_TABLE

NO_TRANSFORM_DISTINCT_AGG

NO_UNNEST

NO_USE_HASH

NO_USE_HASH_AGGREGATION

NO_USE_INVISIBLE_INDEXES

NO_USE_MERGE

NO_USE_NL

NO_XMLINDEX_REWRITE

NO_XMLINDEX_REWRITE_IN_SELECT

NO_XML_DML_REWRITE

NO_XML_QUERY_REWRITE

NTH_VALUE

NTILE

NULL

NULLIF

NULLS

NUMBER

NUMERIC

NUMTODSINTERVAL

NUMTOYMINTERVAL

NUM_INDEX_KEYS

NVARCHAR2

NVL

NVL2

OBJECT

OBJECTTOXML

OBJNO

OBJNO_REUSE

OCCURENCES

OF

OFF

OFFLINE

OID

OIDINDEX

OLAP

OLD

OLD_PUSH_PRED

OLTP

ON

ONLINE

ONLY

OPAQUE

OPAQUE_TRANSFORM

OPAQUE_XCANONICAL

OPCODE

OPEN

OPERATIONS

OPERATOR

OPTIMAL

OPTIMIZER_FEATURES_ENABLE

OPTIMIZER_GOAL

OPTION

OPT_ESTIMATE

OPT_PARAM

OR

ORADEBUG

ORA_BRANCH

ORA_CHECKACL

ORA_DST_AFFECTED

ORA_DST_CONVERT

ORA_DST_ERROR

ORA_GET_ACLIDS

ORA_GET_PRIVILEGES

ORA_HASH

ORA_ROWSCN

ORA_ROWSCN_RAW

ORA_ROWVERSION

ORA_TABVERSION

ORDER

ORDERED

ORDERED_PREDICATES

ORDINALITY

ORGANIZATION

OR_EXPAND

OR_PREDICATES

OTHER

OUTER

OUTER_JOIN_TO_INNER

OUTLINE

OUTLINE_LEAF

OUT_OF_LINE

OVER

OVERFLOW

OVERFLOW_NOMOVE

OVERLAPS

OWN

OWNER

OWNERSHIP

P

PACKAGE

PACKAGES

PARALLEL

PARALLEL_INDEX

PARAM

PARAMETERS

PARENT

PARITY

PART$NUM$INST

PARTIALLY

PARTITION

PARTITIONS

PARTITION_HASH

PARTITION_LIST

PARTITION_RANGE

PASSING

PASSWORD

PASSWORD_GRACE_TIME

PASSWORD_LIFE_TIME

PASSWORD_LOCK_TIME

PASSWORD_REUSE_MAX

PASSWORD_REUSE_TIME

PASSWORD_VERIFY_FUNCTION

PATH

PATHS

PBL_HS_BEGIN

PBL_HS_END

PCTFREE

PCTINCREASE

PCTTHRESHOLD

PCTUSED

PCTVERSION

PENDING

PERCENT

PERCENTILE_CONT

PERCENTILE_DISC

PERCENT_RANK

PERCENT_RANKM

PERFORMANCE

PERMANENT

PERMISSION

PFILE

PHYSICAL

PIKEY

PIVOT

PIV_GB

PIV_SSF

PLACE_DISTINCT

PLACE_GROUP_BY

PLAN

PLSCOPE_SETTINGS

PLSQL_CCFLAGS

PLSQL_CODE_TYPE

PLSQL_DEBUG

PLSQL_OPTIMIZE_LEVEL

PLSQL_WARNINGS

POINT

POLICY

POST_TRANSACTION

POWER

POWERMULTISET

POWERMULTISET_BY_CARDINALITY

PQ_DISTRIBUTE

PQ_MAP

PQ_NOMAP

PREBUILT

PRECEDES

PRECEDING

PRECISION

PRECOMPUTE_SUBQUERY

PREDICATE_REORDERS

PREDICTION

PREDICTION_BOUNDS

PREDICTION_COST

PREDICTION_DETAILS

PREDICTION_PROBABILITY

PREDICTION_SET

PREPARE

PRESENT

PRESENTNNV

PRESENTV

PRESERVE

PRESERVE_OID

PREVIOUS

PRIMARY

PRIOR

PRIVATE

PRIVATE_SGA

PRIVILEGE

PRIVILEGES

PROCEDURAL

PROCEDURE

PROCESS

PROFILE

PROGRAM

PROJECT

PROPAGATE

PROTECTED

PROTECTION

PUBLIC

PULL_PRED

PURGE

PUSH_PRED

PUSH_SUBQ

PX_GRANULE

PX_JOIN_FILTER

QB_NAME

QUERY

QUERY_BLOCK

QUEUE

QUEUE_CURR

QUEUE_ROWP

QUIESCE

QUORUM

QUOTA

RANDOM

RANDOM_LOCAL

RANGE

RANK

RANKM

RAPIDLY

RATIO_TO_REPORT

RAW

RAWTOHEX

RAWTONHEX

RBA

RBO_OUTLINE

RDBA

READ

READS

REAL

REBALANCE

REBUILD

RECORDS_PER_BLOCK

RECOVER

RECOVERABLE

RECOVERY

RECYCLE

RECYCLEBIN

REDO

REDUCED

REDUNDANCY

REF

REFERENCE

REFERENCED

REFERENCES

REFERENCING

REFRESH

REFTOHEX

REF_CASCADE_CURSOR

REGEXP_COUNT

REGEXP_INSTR

REGEXP_LIKE

REGEXP_REPLACE

REGEXP_SUBSTR

REGISTER

REGR_AVGX

REGR_AVGY

REGR_COUNT

REGR_INTERCEPT

REGR_R2

REGR_SLOPE

REGR_SXX

REGR_SXY

REGR_SYY

REGULAR

REJECT

REKEY

RELATIONAL

RELY

REMAINDER

REMOTE_MAPPED

REMOVE

RENAME

REPAIR

REPEAT

REPLACE

REPLICATION

REQUIRED

RESET

RESETLOGS

RESIZE

RESOLVE

RESOLVER

RESOURCE

RESPECT

RESTORE

RESTORE_AS_INTERVALS

RESTRICT

RESTRICTED

RESTRICT_ALL_REF_CONS

RESULT_CACHE

RESUMABLE

RESUME

RETENTION

RETRY_ON_ROW_CHANGE

RETURN

RETURNING

REUSE

REVERSE

REVOKE

REWRITE

REWRITE_OR_ERROR

RIGHT

ROLE

ROLES

ROLLBACK

ROLLING

ROLLUP

ROUND

ROW

ROWDEPENDENCIES

ROWID

ROWIDTOCHAR

ROWIDTONCHAR

ROWNUM

ROWS

ROW_LENGTH

ROW_NUMBER

RPAD

RTRIM

RULE

RULES

SALT

SAMPLE

SAVEPOINT

SAVE_AS_INTERVALS

SB4

SCALE

SCALE_ROWS

SCAN

SCAN_INSTANCES

SCHEDULER

SCHEMA

SCHEMACHECK

SCN

SCN_ASCENDING

SCOPE

SD_ALL

SD_INHIBIT

SD_SHOW

SEARCH

SECOND

SECUREFILE

SECUREFILE_DBA

SECURITY

SEED

SEGMENT

SEG_BLOCK

SEG_FILE

SELECT

SELECTIVITY

SEMIJOIN

SEMIJOIN_DRIVER

SEQUENCE

SEQUENCED

SEQUENTIAL

SERIALIZABLE

SERVERERROR

SESSION

SESSIONS_PER_USER

SESSIONTIMEZONE

SESSIONTZNAME

SESSION_CACHED_CURSORS

SET

SETS

SETTINGS

SET_TO_JOIN

SEVERE

SHARE

SHARED

SHARED_POOL

SHOW

SHRINK

SHUTDOWN

SIBLINGS

SID

SIGN

SIGNAL_COMPONENT

SIGNAL_FUNCTION

SIMPLE

SIN

SINGLE

SINGLETASK

SINH

SIZE

SKIP

SKIP_EXT_OPTIMIZER

SKIP_UNQ_UNUSABLE_IDX

SKIP_UNUSABLE_INDEXES

SMALLFILE

SMALLINT

SNAPSHOT

SOME

SORT

SOUNDEX

SOURCE

SPACE

SPECIFICATION

SPFILE

SPLIT

SPREADSHEET

SQL

SQLLDR

SQL_TRACE

SQRT

STALE

STANDALONE

STANDBY

STANDBY_MAX_DATA_DELAY

STAR

START

STARTUP

STAR_TRANSFORMATION

STATEMENTS

STATEMENT_ID

STATEMENT_QUEUING

STATIC

STATISTICS

STATS_BINOMIAL_TEST

STATS_CROSSTAB

STATS_F_TEST

STATS_KS_TEST

STATS_MODE

STATS_MW_TEST

STATS_ONE_WAY_ANOVA

STATS_T_TEST_INDEP

STATS_T_TEST_INDEPU

STATS_T_TEST_ONE

STATS_T_TEST_PAIRED

STATS_WSR_TEST

STDDEV

STDDEV_POP

STDDEV_SAMP

STOP

STORAGE

STORE

STREAMS

STRICT

STRING

STRIP

STRIPE_COLUMNS

STRIPE_WIDTH

STRUCTURE

SUBMULTISET

SUBPARTITION

SUBPARTITIONS

SUBPARTITION_REL

SUBQUERIES

SUBQUERY_PRUNING

SUBSTITUTABLE

SUBSTR

SUBSTR2

SUBSTR4

SUBSTRB

SUBSTRC

SUCCESSFUL

SUM

SUMMARY

SUPPLEMENTAL

SUSPEND

SWAP_JOIN_INPUTS

SWITCH

SWITCHOVER

SYNC

SYNCHRONOUS

SYNONYM

SYSASM

SYSAUX

SYSDATE

SYSDBA

SYSOPER

SYSTEM

SYSTEM_DEFINED

SYSTIMESTAMP

SYS_AUDIT

SYS_CHECKACL

SYS_CONNECT_BY_PATH

SYS_CONTEXT

SYS_DBURIGEN

SYS_DL_CURSOR

SYS_DM_RXFORM_CHR

SYS_DM_RXFORM_NUM

SYS_DOM_COMPARE

SYS_DST_PRIM2SEC

SYS_DST_SEC2PRIM

SYS_ET_BFILE_TO_RAW

SYS_ET_BLOB_TO_IMAGE

SYS_ET_IMAGE_TO_BLOB

SYS_ET_RAW_TO_BFILE

SYS_EXTPDTXT

SYS_EXTRACT_UTC

SYS_FBT_INSDEL

SYS_FILTER_ACLS

SYS_GETTOKENID

SYS_GET_ACLIDS

SYS_GET_PRIVILEGES

SYS_GUID

SYS_MAKEXML

SYS_MAKE_XMLNODEID

SYS_MKXMLATTR

SYS_OPTLOBPRBSC

SYS_OPTXICMP

SYS_OPTXQCASTASNQ

SYS_OP_ADT2BIN

SYS_OP_ADTCONS

SYS_OP_ALSCRVAL

SYS_OP_ATG

SYS_OP_BIN2ADT

SYS_OP_BITVEC

SYS_OP_BL2R

SYS_OP_BLOOM_FILTER

SYS_OP_BLOOM_FILTER_LIST

SYS_OP_C2C

SYS_OP_CAST

SYS_OP_CEG

SYS_OP_CL2C

SYS_OP_COMBINED_HASH

SYS_OP_COMP

SYS_OP_CONVERT

SYS_OP_COUNTCHG

SYS_OP_CSCONV

SYS_OP_CSCONVTEST

SYS_OP_CSR

SYS_OP_CSX_PATCH

SYS_OP_DECOMP

SYS_OP_DESCEND

SYS_OP_DISTINCT

SYS_OP_DRA

SYS_OP_DUMP

SYS_OP_ENFORCE_NOT_NULL$

SYS_OP_EXTRACT

SYS_OP_GROUPING

SYS_OP_GUID

SYS_OP_IIX

SYS_OP_ITR

SYS_OP_LBID

SYS_OP_LOBLOC2BLOB

SYS_OP_LOBLOC2CLOB

SYS_OP_LOBLOC2ID

SYS_OP_LOBLOC2NCLOB

SYS_OP_LOBLOC2TYP

SYS_OP_LSVI

SYS_OP_LVL

SYS_OP_MAKEOID

SYS_OP_MAP_NONNULL

SYS_OP_MSR

SYS_OP_NICOMBINE

SYS_OP_NIEXTRACT

SYS_OP_NII

SYS_OP_NIX

SYS_OP_NOEXPAND

SYS_OP_NTCIMG$

SYS_OP_NUMTORAW

SYS_OP_OIDVALUE

SYS_OP_OPNSIZE

SYS_OP_PAR

SYS_OP_PARGID

SYS_OP_PARGID_1

SYS_OP_PAR_1

SYS_OP_PIVOT

SYS_OP_R2O

SYS_OP_RAWTONUM

SYS_OP_RDTM

SYS_OP_REF

SYS_OP_RMTD

SYS_OP_ROWIDTOOBJ

SYS_OP_RPB

SYS_OP_TOSETID

SYS_OP_TPR

SYS_OP_TRTB

SYS_OP_UNDESCEND

SYS_OP_VECAND

SYS_OP_VECBIT

SYS_OP_VECOR

SYS_OP_VECXOR

SYS_OP_VERSION

SYS_OP_VREF

SYS_OP_VVD

SYS_OP_XPTHATG

SYS_OP_XPTHIDX

SYS_OP_XPTHOP

SYS_OP_XTXT2SQLT

SYS_ORDERKEY_DEPTH

SYS_ORDERKEY_MAXCHILD

SYS_ORDERKEY_PARENT

SYS_PARALLEL_TXN

SYS_PATHID_IS_ATTR

SYS_PATHID_IS_NMSPC

SYS_PATHID_LASTNAME

SYS_PATHID_LASTNMSPC

SYS_PATH_REVERSE

SYS_PXQEXTRACT

SYS_RID_ORDER

SYS_ROW_DELTA

SYS_SC_2_XMLT

SYS_SYNRCIREDO

SYS_TYPEID

SYS_UMAKEXML

SYS_XMLANALYZE

SYS_XMLCONTAINS

SYS_XMLCONV

SYS_XMLEXNSURI

SYS_XMLGEN

SYS_XMLI_LOC_ISNODE

SYS_XMLI_LOC_ISTEXT

SYS_XMLLOCATOR_GETSVAL

SYS_XMLNODEID

SYS_XMLNODEID_GETCID

SYS_XMLNODEID_GETLOCATOR

SYS_XMLNODEID_GETOKEY

SYS_XMLNODEID_GETPATHID

SYS_XMLNODEID_GETPTRID

SYS_XMLNODEID_GETRID

SYS_XMLNODEID_GETSVAL

SYS_XMLNODEID_GETTID

SYS_XMLTRANSLATE

SYS_XMLTYPE2SQL

SYS_XMLT_2_SC

SYS_XQBASEURI

SYS_XQCASTABLEERRH

SYS_XQCODEP2STR

SYS_XQCODEPEQ

SYS_XQCON2SEQ

SYS_XQCONCAT

SYS_XQDELETE

SYS_XQDFLTCOLATION

SYS_XQDOC

SYS_XQDOCURI

SYS_XQED4URI

SYS_XQENDSWITH

SYS_XQERR

SYS_XQERRH

SYS_XQESHTMLURI

SYS_XQEXLOBVAL

SYS_XQEXSTWRP

SYS_XQEXTRACT

SYS_XQEXTRREF

SYS_XQEXVAL

SYS_XQFB2STR

SYS_XQFNBOOL

SYS_XQFNCMP

SYS_XQFNDATIM

SYS_XQFNLNAME

SYS_XQFNNM

SYS_XQFNNSURI

SYS_XQFNPREDTRUTH

SYS_XQFNQNM

SYS_XQFNROOT

SYS_XQFORMATNUM

SYS_XQFTCONTAIN

SYS_XQFUNCR

SYS_XQGETCONTENT

SYS_XQINDXOF

SYS_XQINSERT

SYS_XQINSPFX

SYS_XQIRI2URI

SYS_XQLANG

SYS_XQLLNMFRMQNM

SYS_XQMKNODEREF

SYS_XQNILLED

SYS_XQNODENAME

SYS_XQNORMSPACE

SYS_XQNORMUCODE

SYS_XQNSP4PFX

SYS_XQNSPFRMQNM

SYS_XQPFXFRMQNM

SYS_XQPOLYABS

SYS_XQPOLYADD

SYS_XQPOLYCEL

SYS_XQPOLYCST

SYS_XQPOLYCSTBL

SYS_XQPOLYDIV

SYS_XQPOLYFLR

SYS_XQPOLYMOD

SYS_XQPOLYMUL

SYS_XQPOLYRND

SYS_XQPOLYSQRT

SYS_XQPOLYSUB

SYS_XQPOLYUMUS

SYS_XQPOLYUPLS

SYS_XQPOLYVEQ

SYS_XQPOLYVGE

SYS_XQPOLYVGT

SYS_XQPOLYVLE

SYS_XQPOLYVLT

SYS_XQPOLYVNE

SYS_XQREF2VAL

SYS_XQRENAME

SYS_XQREPLACE

SYS_XQRESVURI

SYS_XQRNDHALF2EVN

SYS_XQRSLVQNM

SYS_XQRYENVPGET

SYS_XQRYVARGET

SYS_XQRYWRP

SYS_XQSEQ2CON

SYS_XQSEQ2CON4XC

SYS_XQSEQDEEPEQ

SYS_XQSEQINSB

SYS_XQSEQRM

SYS_XQSEQRVS

SYS_XQSEQSUB

SYS_XQSEQTYPMATCH

SYS_XQSTARTSWITH

SYS_XQSTATBURI

SYS_XQSTR2CODEP

SYS_XQSTRJOIN

SYS_XQSUBSTRAFT

SYS_XQSUBSTRBEF

SYS_XQTOKENIZE

SYS_XQTREATAS

SYS_XQXFORM

SYS_XQ_ASQLCNV

SYS_XQ_ATOMCNVCHK

SYS_XQ_NRNG

SYS_XQ_PKSQL2XML

SYS_XQ_UPKXML2SQL

T

TABLE

TABLES

TABLESPACE

TABLESPACE_NO

TABLE_STATS

TABNO

TAN

TANH

TBL$OR$IDX$PART$NUM

TEMPFILE

TEMPLATE

TEMPORARY

TEMP_TABLE

TEST

THAN

THE

THEN

THREAD

THROUGH

TIME

TIMEOUT

TIMES

TIMESTAMP

TIMEZONE_ABBR

TIMEZONE_HOUR

TIMEZONE_MINUTE

TIMEZONE_OFFSET

TIMEZONE_REGION

TIME_ZONE

TIV_GB

TIV_SSF

TO

TOPLEVEL

TO_BINARY_DOUBLE

TO_BINARY_FLOAT

TO_BLOB

TO_CHAR

TO_CLOB

TO_DATE

TO_DSINTERVAL

TO_LOB

TO_MULTI_BYTE

TO_NCHAR

TO_NCLOB

TO_NUMBER

TO_SINGLE_BYTE

TO_TIME

TO_TIMESTAMP

TO_TIMESTAMP_TZ

TO_TIME_TZ

TO_YMINTERVAL

TRACE

TRACING

TRACKING

TRAILING

TRANSACTION

TRANSFORM_DISTINCT_AGG

TRANSITION

TRANSITIONAL

TRANSLATE

TREAT

TRIGGER

TRIGGERS

TRIM

TRUE

TRUNC

TRUNCATE

TRUSTED

TUNING

TX

TYPE

TYPES

TZ_OFFSET

U

UB2

UBA

UID

UNARCHIVED

UNBOUND

UNBOUNDED

UNDER

UNDO

UNDROP

UNIFORM

UNION

UNIQUE

UNISTR

UNLIMITED

UNLOCK

UNNEST

UNPACKED

UNPIVOT

UNPROTECTED

UNQUIESCE

UNRECOVERABLE

UNRESTRICTED

UNTIL

UNUSABLE

UNUSED

UPDATABLE

UPDATE

UPDATED

UPDATEXML

UPD_INDEXES

UPD_JOININDEX

UPGRADE

UPPER

UPSERT

UROWID

USAGE

USE

USER

USERENV

USERGROUP

USERS

USER_DEFINED

USER_RECYCLEBIN

USE_ANTI

USE_CONCAT

USE_HASH

USE_HASH_AGGREGATION

USE_INVISIBLE_INDEXES

USE_MERGE

USE_MERGE_CARTESIAN

USE_NL

USE_NL_WITH_INDEX

USE_PRIVATE_OUTLINES

USE_SEMI

USE_STORED_OUTLINES

USE_TTT_FOR_GSETS

USE_WEAK_NAME_RESL

USING

VALIDATE

VALIDATION

VALUE

VALUES

VARCHAR

VARCHAR2

VARIANCE

VARRAY

VARRAYS

VARYING

VAR_POP

VAR_SAMP

VECTOR_READ

VECTOR_READ_TRACE

VERIFY

VERSION

VERSIONING

VERSIONS

VERSIONS_ENDSCN

VERSIONS_ENDTIME

VERSIONS_OPERATION

VERSIONS_STARTSCN

VERSIONS_STARTTIME

VERSIONS_XID

VIEW

VIRTUAL

VISIBLE

VOLUME

VSIZE

WAIT

WALLET

WELLFORMED

WHEN

WHENEVER

WHERE

WHITESPACE

WIDTH_BUCKET

WITH

WITHIN

WITHOUT

WORK

WRAPPED

WRITE

XID

XML

XMLATTRIBUTES

XMLCAST

XMLCDATA

XMLCOLATTVAL

XMLCOMMENT

XMLCONCAT

XMLDIFF

XMLELEMENT

XMLEXISTS

XMLEXISTS2

XMLFOREST

XMLINDEX_REWRITE

XMLINDEX_REWRITE_IN_SELECT

XMLINDEX_SEL_IDX_TBL

XMLISNODE

XMLISVALID

XMLNAMESPACES

XMLPARSE

XMLPATCH

XMLPI

XMLQUERY

XMLROOT

XMLSCHEMA

XMLSERIALIZE

XMLTABLE

XMLTOOBJECT

XMLTRANSFORM

XMLTRANSFORMBLOB

XMLTYPE

XML_DML_RWT_STMT

XPATHTABLE

XS_SYS_CONTEXT

X_DYN_PRUNE

YEAR

YES

ZONE

[

]

^

{

|

}

SQLServer

下表列出了 SQL Server 保留关键字。

add

EXTERNAL

PROCEDURE

ALL

FETCH

PUBLIC

ALTER

FILE

RAISERROR

And

FILLFACTOR

READ

ANY

FOR

READTEXT

As

FOREIGN

RECONFIGURE

ASC

FREETEXT

REFERENCES

AUTHORIZATION

FREETEXTTABLE

REPLICATION

BACKUP

from

RESTORE

BEGIN

FULL

RESTRICT

BETWEEN

FUNCTION

RETURN

BREAK

GOTO

REVERT

BROWSE

GRANT

REVOKE

BULK

GROUP

RIGHT

BY

HAVING

ROLLBACK

CASCADE

HOLDLOCK

ROWCOUNT

Case

IDENTITY

ROWGUIDCOL

CHECK

IDENTITY_INSERT

RULE

CHECKPOINT

IDENTITYCOL

SAVE

close

IF

SCHEMA

CLUSTERED

IN

SECURITYAUDIT

COALESCE

INDEX

SELECT

COLLATE

INNER

SEMANTICKEYPHRASETABLE

COLUMN

INSERT

SEMANTICSIMILARITYDETAILSTABLE

COMMIT

INTERSECT

SEMANTICSIMILARITYTABLE

COMPUTE

INTO

SESSION_USER

CONSTRAINT

is

SET

CONTAINS

JOIN

SETUSER

CONTAINSTABLE

KEY

SHUTDOWN

CONTINUE

KILL

SOME

CONVERT

LEFT

STATISTICS

CREATE

LIKE

SYSTEM_USER

CROSS

LINENO

TABLE

CURRENT

LOAD

TABLESAMPLE

CURRENT_DATE

MERGE

TEXTSIZE

CURRENT_TIME

NATIONAL

THEN

CURRENT_TIMESTAMP

NOCHECK

目标

CURRENT_USER

NONCLUSTERED

TOP

CURSOR

NOT

TRAN

DATABASE

NULL

TRANSACTION

DBCC

NULLIF

Trigger

DEALLOCATE

OF

TRUNCATE

DECLARE

OFF

TRY_CONVERT

DEFAULT

OFFSETS

TSEQUAL

delete

ON

UNION

DENY

OPEN

UNIQUE

DESC

OPENDATASOURCE

UNPIVOT

DISK

OPENQUERY

UPDATE

DISTINCT

OPENROWSET

UPDATETEXT

DISTRIBUTED

OPENXML

USE

DOUBLE

OPTION

USER

DROP

OR

VALUES

DUMP

ORDER

VARYING

Else

OUTER

View

END

OVER

WAITFOR

ERRLVL

PERCENT

WHEN

ESCAPE

PIVOT

WHERE

EXCEPT

PLAN

WHILE

EXEC

PRECISION

WITH

EXECUTE

PRIMARY

WITHIN GROUP

EXISTS

PRINT

WRITETEXT

EXIT

PROC

此外，ISO 标准定义了保留关键字列表。 不要使用 ISO 保留关键字作为对象名和标识符。 ODBC 保留关键字列表(如下表所示)与 ISO 保留关键字列表相同。

注意

ISO 标准保留关键字有时可能比 SQL Server 限制更多，有时则更少。 例如，ISO 保留关键字列表包含 INT。 SQL Server 不必将此区分为保留关键字。

Transact-SQL 保留关键字可用作数据库或数据库对象(如表、列、视图等)的标识符或名称。 使用带引号的标识符或分隔标识符。 不限制将保留关键字用作变量和存储过程参数的名

ODBC 保留关键字

保留了下列关键字以用于 ODBC 函数调用。这些关键字根本不约束 SQL 语法；然而，为确保与支持核心 SQL 语法的驱动程序兼容，应用程序应避免使用这些关键字。

下面是当前的 ODBC 保留关键字列表。

ABSOLUTE

EXEC

OVERLAPS

ACTION

EXECUTE

PAD

ADA

EXISTS

PARTIAL

ADD

EXTERNAL

PASCAL

ALL

EXTRACT

POSITION

ALLOCATE

FALSE

PRECISION

ALTER

FETCH

PREPARE

AND

FIRST

PRESERVE

ANY

FLOAT

PRIMARY

ARE

FOR

PRIOR

AS

FOREIGN

PRIVILEGES

ASC

FORTRAN

PROCEDURE

ASSERTION

FOUND

PUBLIC

AT

FROM

READ

AUTHORIZATION

FULL

REAL

AVG

GET

REFERENCES

BEGIN

GLOBAL

RELATIVE

BETWEEN

GO

RESTRICT

BIT

GOTO

REVOKE

BIT_LENGTH

GRANT

RIGHT

BOTH

GROUP

ROLLBACK

BY

HAVING

ROWS

CASCADE

HOUR

SCHEMA

CASCADED

IDENTITY

SCROLL

CASE

IMMEDIATE

SECOND

CAST

IN

SECTION

CATALOG

INCLUDE

SELECT

CHAR

INDEX

SESSION

CHAR_LENGTH

INDICATOR

SESSION_USER

CHARACTER

INITIALLY

SET

CHARACTER_LENGTH

INNER

SIZE

CHECK

INPUT

SMALLINT

CLOSE

INSENSITIVE

SOME

COALESCE

INSERT

SPACE

COLLATE

INT

SQL

COLLATION

INTEGER

SQLCA

COLUMN

INTERSECT

SQLCODE

COMMIT

INTERVAL

SQLERROR

CONNECT

INTO

SQLSTATE

CONNECTION

IS

SQLWARNING

CONSTRAINT

ISOLATION

SUBSTRING

CONSTRAINTS

JOIN

SUM

CONTINUE

KEY

SYSTEM_USER

CONVERT

LANGUAGE

TABLE

CORRESPONDING

LAST

TEMPORARY

COUNT

LEADING

THEN

CREATE

LEFT

TIME

CROSS

LEVEL

TIMESTAMP

CURRENT

LIKE

TIMEZONE_HOUR

CURRENT_DATE

LOCAL

TIMEZONE_MINUTE

CURRENT_TIME

LOWER

TO

CURRENT_TIMESTAMP

MATCH

TRAILING

CURRENT_USER

MAX

TRANSACTION

CURSOR

MIN

TRANSLATE

DATE

MINUTE

TRANSLATION

DAY

MODULE

TRIM

DEALLOCATE

MONTH

TRUE

DEC

NAMES

UNION

DECIMAL

NATIONAL

UNIQUE

DECLARE

NATURAL

UNKNOWN

DEFAULT

NCHAR

UPDATE

DEFERRABLE

NEXT

UPPER

DEFERRED

NO

USAGE

DELETE

NONE

USER

DESC

NOT

USING

DESCRIBE

NULL

VALUE

DESCRIPTOR

NULLIF

VALUES

DIAGNOSTICS

NUMERIC

VARCHAR

DISCONNECT

OCTET_LENGTH

VARYING

DISTINCT

OF

VIEW

DOMAIN

ON

WHEN

DOUBLE

ONLY

WHENEVER

DROP

OPEN

WHERE

ELSE

OPTION

WITH

END

OR

WORK

END-EXEC

ORDER

WRITE

ESCAPE

OUTER

YEAR

EXCEPT

OUTPUT

ZONE

EXCEPTION

将来的关键字

下列关键字可能会在将来的 SQL Server 版本中保留使用，作为将来要实现的新功能。注意，不要使用这些关键字作为标识符。

ABSOLUTE

HOST

RELATIVE

ACTION

HOUR

RELEASE

ADMIN

IGNORE

RESULT

AFTER

IMMEDIATE

RETURNS

AGGREGATE

INDICATOR

ROLE

ALIAS

INITIALIZE

ROLLUP

ALLOCATE

INITIALLY

ROUTINE

ARE

INOUT

ROW

ARRAY

INPUT

ROWS

ASENSITIVE

INT

SAVEPOINT

ASSERTION

INTEGER

SCROLL

ASYMMETRIC

INTERSECTION

SCOPE

AT

INTERVAL

SEARCH

ATOMIC

ISOLATION

SECOND

BEFORE

ITERATE

SECTION

BINARY

LANGUAGE

SENSITIVE

BIT

LARGE

SEQUENCE

BLOB

LAST

SESSION

BOOLEAN

LATERAL

SETS

BOTH

LEADING

SIMILAR

BREADTH

LESS

SIZE

CALL

LEVEL

SMALLINT

CALLED

LIKE_REGEX

SPACE

CARDINALITY

LIMIT

SPECIFIC

CASCADED

LN

SPECIFICTYPE

CAST

LOCAL

SQL

CATALOG

LOCALTIME

SQLEXCEPTION

CHAR

LOCALTIMESTAMP

SQLSTATE

CHARACTER

LOCATOR

SQLWARNING

CLASS

MAP

START

CLOB

MATCH

STATE

COLLATION

MEMBER

STATEMENT

COLLECT

METHOD

STATIC

COMPLETION

MINUTE

STDDEV_POP

CONDITION

MOD

STDDEV_SAMP

CONNECT

MODIFIES

STRUCTURE

CONNECTION

MODIFY

SUBMULTISET

CONSTRAINTS

MODULE

SUBSTRING_REGEX

CONSTRUCTOR

MONTH

SYMMETRIC

CORR

MULTISET

SYSTEM

CORRESPONDING

NAMES

TEMPORARY

COVAR_POP

NATURAL

TERMINATE

COVAR_SAMP

NCHAR

THAN

CUBE

NCLOB

TIME

CUME_DIST

NEW

TIMESTAMP

CURRENT_CATALOG

NEXT

TIMEZONE_HOUR

CURRENT_DEFAULT_TRANSFORM_GROUP

NO

TIMEZONE_MINUTE

CURRENT_PATH

NONE

TRAILING

CURRENT_ROLE

NORMALIZE

TRANSLATE_REGEX

CURRENT_SCHEMA

NUMERIC

TRANSLATION

CURRENT_TRANSFORM_GROUP_FOR_TYPE

OBJECT

TREAT

CYCLE

OCCURRENCES_REGEX

TRUE

DATA

OLD

UESCAPE

DATE

ONLY

UNDER

DAY

OPERATION

UNKNOWN

DEC

ORDINALITY

UNNEST

DECIMAL

OUT

USAGE

DEFERRABLE

OVERLAY

USING

DEFERRED

OUTPUT

VALUE

DEPTH

PAD

VAR_POP

DEREF

PARAMETER

VAR_SAMP

DESCRIBE

PARAMETERS

VARCHAR

DESCRIPTOR

PARTIAL

VARIABLE

DESTROY

PARTITION

WHENEVER

DESTRUCTOR

PATH

WIDTH_BUCKET

DETERMINISTIC

POSTFIX

WITHOUT

DICTIONARY

PREFIX

WINDOW

DIAGNOSTICS

PREORDER

WITHIN

DISCONNECT

PREPARE

WORK

DOMAIN

PERCENT_RANK

WRITE

DYNAMIC

PERCENTILE_CONT

XMLAGG

EACH

PERCENTILE_DISC

XMLATTRIBUTES

ELEMENT

POSITION_REGEX

XMLBINARY

END-EXEC

PRESERVE

XMLCAST

EQUALS

PRIOR

XMLCOMMENT

EVERY

PRIVILEGES

XMLCONCAT

EXCEPTION

RANGE

XMLDOCUMENT

FALSE

READS

XMLELEMENT

FILTER

REAL

XMLEXISTS

FIRST

RECURSIVE

XMLFOREST

FLOAT

REF

XMLITERATE

FOUND

REFERENCING

XMLNAMESPACES

FREE

REGR_AVGX

XMLPARSE

FULLTEXTTABLE

REGR_AVGY

XMLPI

FUSION

REGR_COUNT

XMLQUERY

GENERAL

REGR_INTERCEPT

XMLSERIALIZE

GET

REGR_R2

XMLTABLE

GLOBAL

REGR_SLOPE

XMLTEXT

GO

REGR_SXX

XMLVALIDATE

GROUPING

REGR_SXY

YEAR

HOLD

REGR_SYY

ZONE

总结

备注：

本站点所有随笔都是原创，欢迎大家转载；但转载时必须注明文章来源，且在文章开头明显处给明链接。

《欢迎交流讨论》