关键字是指在数据库中有意义的字，通常是数据库内部使用， 不能用于命名用户的数据对象。 有的数据库还会详细划分，例如分为关键字，候选字，甚至更详细的分类。分类的标准例如有的是绝对不可以使用，有的通过一定手段例如添加双引号可以使用。

我们为了方便统一称之为关键字，通常用户编写的对象中使用关键字会造成错误或不确定的影响，为了避免这个问题，用户应该避免使用数据库的关键字(含保留字或其他保留别名等)。

这个系列主要整理了各大数据库的关键字，可以用于建库，建表，写存储过程，函数等场景避免冲突。最后会有个脚本工具用来检查是否使用关键字。

9de7bb31d0644e7393039222babfed10

欢迎收藏。

以下不带*号的为关键字，带*号的为系统保留字。

DM 还将保留字进一步划分为 SQL 保留字、 DMSQL 程序保留字、模式保留字、变量保留字和别名保留字，具体请查询系统视图 V$RESERVED_WORDS。

注意：关键字 ROWID、 TRXID、 VERSIONS_STARTTIME、 VERSIONS_ENDTIME、VERSIONS_STARTTRXID、 VERSIONS_ENDTRXID 和 VERSIONS_OPERATION 不能作为表的列名，即使加上双引号也不行。

ABORT ABSOLUTE ABSTRACT ACCESSED ACCOUNT ACROSS ACTION ADD ADMIN AFTER AGGREGATE ALL ALLOW_DATETIME ALLOW_IP ALTER ANALYZE AND ANY ARCHIVE ARCHIVEDIR ARCHIVELOG ARCHIVESTYLE ARRAY ARRAYLEN AS ASC ASENSITIVE ASSIGN ASYNCHRONOUS AT ATTACH AUDIT AUTHID AUTHORIZATION AUTO AUTOEXTEND AUTONOMOUS_TRANSACTION AVG

BACKED BACKUP BACKUPDIR BACKUPINFO BACKSET BADFILE BAKFILE BASE BEFORE BEGIN BETWEEN BIGDATEDIFF BIGINT BINARY BIT BITMAP BLOB BLOCK BOOL BOOLEAN BOTH BRANCH BREAK BSTRING BTREE BUFFER BUILD BULK BY BYTE

CACHE CALCULATE CALL CASCADE CASCADED CASE CAST CATALOG CATCH CHAIN CHAR CHARACTER CHARACTERISTICS CHECK CIPHER CLASS CLOB CLOSE LUSTER CLUSTERBTR COLLATE COLLATION COLLECT COLUMN COLUMNS COMMENT COMMIT COMMITTED COMMITWORK COMPILE COMPLETE COMPRESS COMPRESSED CONNECT CONNECT_BY_IS_CYCLE CONNECT_BY_ISLEAF CONNECT_BY_ROOT CONNECT_IDLE_TIME CONNECT_TIME CONST CONSTANT CONSTRAINT CONSTRAINTS CONSTRUCTOR CONTAINS CONTEXT CONTINUE CONVERT COPY CORRESPONDING COUNT COUNTER CPU_PER_CALL CPU_PER_SESSION CREATE CROSS CRYPTO CTLFILE CUBE CUMULATIVE CURRENT CURRENT_SCHEMA CURRENT_USER CURSOR CYCLE

DANGLING DATA DATABASE DATAFILE DATE DATEADD DATEDIFF DATEPART DATETIME DAY DBFILE DDL DDL_CLONE DEBUG DEC DECIMAL DECLARE DECODE DEFAULT DEFERRABLE DEFERRED DEFINER DELETE DELETING DELIMITED DELTA DEMAND DENSE_RANK DEREF DESC DETACH DETERMINISTIC DEVICE DIAGNOSTICS DICTIONARY DISABLE DISCONNECT DISKSPACE DISTINCT DISTRIBUTED DO DOMAIN DOUBLE DOWN DROP DUMP

EACH ELSE ELSEIF ELSIF ENABLE ENCRYPT ENCRYPTION END EQU ERROR ERRORS ESCAPE EVENTINFO EVENTS EXCEPT EXCEPTION EXCEPTIONS EXCEPTION_INIT EXCHANGE EXCLUDE EXCLUDING EXCLUSIVE EXEC EXECUTE EXISTS EXIT EXPLAIN EXTENDS EXTERN EXTERNAL EXTERNALLY EXTRACT

FAILED_LOGIN_ATTEMPS FAST FETCH FIELDS FILE FILEGROUP FILESIZE FILLFACTOR FINAL FINALLY FIRST FLOAT FOLLOWING FOR FORALL FORCE FOREIGN FREQUENCE FROM FULL FULLY FUNCTION

GET GLOBAL GLOBALLY GOTO GRANT GROUP GROUPING

HASH HAVING HEXTORAW HOLD HOUR HUGE

IDENTIFIED IDENTITY IDENTITY_INSERT IF IMAGE IMMEDIATE IN INCLUDE INCLUDING INCREASE INCREMENT INDEX INDEXES INDICES INITIAL INITIALIZED INITIALLY INLINE INNER INNERID INPUT INSENSITIVE INSERT INSERTING INSTANTIABLE INSTEAD INT INTEGER INTENT INTERNAL INTERSECT INTERVAL INTO INVISIBLE IS ISOLATION

JAVA JOB JOIN

KEEP KEY

LABEL LARGE LAST LEADING LEFT LESS LEVEL LEXER LIKE LIMIT LINK LIST LNNVL LOB LOCAL LOCALLY LOCK LOCKED LOG LOGFILE LOGGING LOGIC LOGIN LOGOFF LOGON LOGOUT LONG LONGVARBINARY LONGVARCHAR LOOP LSN

MANUAL MAP MAPPED MATCH MATCHED MATERIALIZED MAX MAXPIECESIZE MAXSIZE MAXVALUE MEMBER MEMORY MEM_SPACE MERGE MIN MINEXTENTS MINUS MINUTE MINVALUE MIRROR MOD MODE MODIFY MONEY MONITORING MONTH MOUNT MOVEMENT

NATIONAL NATURAL NCHAR NCHARACTER NEVER NEW NEXT NO NOARCHIVELOG NOAUDIT NOBRANCH NOCACHE NOCOPY NOCYCLE NOLOGGING NOMAXVALUE NOMINVALUE NOMONITORING NONE NOORDER NORMAL NOSORT NOT NOT_ALLOW_DATETIME NOT_ALLOW_IP NOWAIT NULL NULLS NUMBER NUMERIC

OBJECT OF OFF OFFLINE OFFSET OLD ON ONCE ONLINE ONLY OPEN OPTIMIZE OPTION OR ORDER OUT OUTER OVER OVERLAPS OVERLAY OVERRIDE OVERRIDING

PACKAGE PAD PAGE PARALLEL PARALLEL_ENABLE PARMS PARTIAL PARTITION PARTITIONS PASSING PASSWORD_GRACE_TIME PASSWORD_LIFE_TIME PASSWORD_LOCK_TIME PASSWORD_POLICY PASSWORD_REUSE_MAX PASSWORD_REUSE_TIME PATH PENDANT PERCENT PIPE PIPELINED PIVOT PLACING PLS_INTEGER PRAGMA PRECEDING PRECISION PRESERVE PRIMARY PRINT PRIOR PRIVATE PRIVILEGE PRIVILEGES PROCEDURE PROTECTED PUBLIC PURGE

QUERY_REWRITE_INTEGRITY

RAISE RANDOMLY RANGE RAWTOHEX READ READONLY READ_PER_CALL READ_PER_SESSION REAL REBUILD RECORD RECORDS REF REFERENCE REFERENCES REFERENCING REFRESH RELATED RELATIVE RENAME REPEAT REPEATABLE REPLACE REPLAY REPLICATE RESIZE RESTORE RESTRICT RESULT RESULT_CACHE RETURN RETURNING REVERSE REVOKE RIGHT ROLE ROLLBACK ROLLFILE ROLLUP ROOT ROW ROWCOUNT ROWID ROWNUM ROWS RULE

SALT SAMPLE SAVE SAVEPOINT SBYTE SCHEMA SCOPE SCROLL SEALED SECOND SECTION SEED SELECT SELF SENSITIVE SEQUENCE SERERR SERIALIZABLE SERVER SESSION SESSION_PER_USER SET SETS SHARE SHORT SHUTDOWN SIBLINGS SIMPLE SINCE SIZE SIZEOF SKIP SMALLINT SNAPSHOT SOME SOUND SPACE SPATIAL SPFILE SPLIT SQL STANDBY STARTUP STAT STATEMENT STATIC STDDEV STORAGE STORE STRING STRUCT STYLE SUBPARTITION SUBPARTITIONS SUBSTRING SUBTYPE SUCCESSFUL SUM SUSPEND SWITCH SYNC SYNCHRONOUS SYNONYM SYSTEM SYS_CONNECT_BY_PATH

TABLE TABLESPACE TASK TEMPLATE TEMPORARY TEXT THAN THEN THREAD THROW TIES TIME TIMER TIMES TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TIME_ZONE TINYINT TO TOP TRACE TRAILING TRANSACTION TRANSACTIONAL TRIGGER TRIGGERS TRIM TRUNCATE TRUNCSIZE TRXID TRY TYPE TYPEDEF TYPEOF

UINT ULONG UNBOUNDED UNCOMMITTED UNDER UNION UNIQUE UNLIMITED UNLOCK UNPIVOT UNTIL UNUSABLE UP UPDATE UPDATING USAGE USER USE_HASH USE_MERGE USE_NL USE_NL_WITH_INDEX USHORT USING

VALUE VALUES VARBINARY VARCHAR VARCHAR2 VARIANCE VARRAY VARYING VERIFY VERSIONS VERSIONS_STARTTIME VERSIONS_ENDTIME VERSIONS_STARTTRXID VERSIONS_ENDTRXID VERSIONS_OPERATION VERTICAL VIEW VIRTUAL VISIBLE VOID VOLATILE VSIZE

WAIT WEEK WHEN WHENEVER WHERE WHILE WITH WITHIN WITHOUT WORK WRAPPED WRITE

XML XMLTABLE

YEAR

ZONE