数据库关键字整理之——Dameng关键字

Bertha 。 2024-03-23 14:38 20阅读 0赞

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

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

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

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