数据库的创建关键字
数据库 关键字一览表数据库 关键字:
为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出mysql、oracle、sqlserver三个数据库各自的保留关键字。
Mysql
http://dev.mysql.com/doc/refman/5.7/en/keywords.html
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)
li (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
XID[ag]
XML
XOR (R)
YEAR
YEAR_MONTH (R)
ZEROFILL (R)
Oracle
select * from v$reserved_words order by keyword 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_XQPOLYli 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
https://msdn.microsoft.com/zh-cn/library/ms189822
下表列出了 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
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!