数据库 关键字:

为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出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)
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 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_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

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

感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注