介绍
为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出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
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
总结
备注:
本站点所有随笔都是原创,欢迎大家转载;但转载时必须注明文章来源,且在文章开头明显处给明链接。
《欢迎交流讨论》