目录

达梦数据库关键字介绍

达梦数据库关键字介绍

达梦数据库 关键字和 保留字

环境介绍

  • **以下不带 * 号的为关键字,带 * 号的为系统保留字

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

SELECT * FROM V$RESERVED_WORDS;

1 特殊关键字(无法屏蔽)

  • 不能作为表的列名,即使加上双引号也不行
  ROWID、 TRXID、 VERSIONS_STARTTIME、 VERSIONS_ENDTIME、
  VERSIONS_STARTTRXID、 VERSIONS_ENDTRXID
 和  VERSIONS_OPERATION 

2 屏蔽关键字

  • 以下的可以加 双引号,若程序中使用到的关键字较多,手动加双引号 工作量会成正比增加那么有两种方法来简单解决

2.1 方法1 配置dm.ini (推荐)

  • **EXCLUDE_RESERVED_WORDS 参数名后面追加关键字

    重启数据库服务生效**

2.1.1 执行SQL后重启数据库服务

SP_SET_PARA_STRING_VALUE(2,'EXCLUDE_RESERVED_WORDS','DOMAIN,ADMIN,DATA');

COMMIT;

SELECT PARA_VALUE,FILE_VALUE FROM V$DM_INI WHERE PARA_NAME='EXCLUDE_RESERVED_WORDS';

2.2.2 直接修改 dm.ini 后重启数据库服务

EXCLUDE_RESERVED_WORDS =DOMAIN,ADMIN,DATA

2.2 方法2 配置dm_svc.conf

参数名默认值简述
KEYWORDS标识用户关键字,所有在列表中的字符串,如果以单词的形式出现在 SQL 语句中,则这个单词会被加上双引号。该参数主要用来解决用户需要使用 DM8 中的保留字作为对象名使用的状况。

2.3 关键字列表

  • **V$RESERVED_WORDS 保留字统计表,

    记录保留字的分类信息。 RES_FIXED=N 的关键字,

    通过 ini 参数 EXCLUDE_RESERVED_WORDS 设置之后会失 效,此视图不会再记录。**


A
ABORT* ABSOLUTE* ABSTRACTACCESSEDACCOUNTACROSSACTION
* ADD* ADMINADVANCEDAFTERAGGREGATE* ALLALLOW_DATETIME
ALLOW_IP* ALTERANALYZE* AND* ANYAPRARCHIVEARCHIVEDIR
ARCHIVELOGARCHIVESTYLE* ARRAY* ARRAYLEN* AS* ASCASCII
ASENSITIVE* ASSIGNASYNCHRONOUSATATTACH* AUDITAUGAUTHID
* AUTHORIZATIONAUTOAUTOEXTENDAUTONOMOUS_TRANSACTIONAVG
B
BACKEDBACKUPBACKUPDIRBACKUPINFOBACKUPSETBADFILEBAKFILE
BASEBEFORE* BEGIN* BETWEEN* BIGDATEDIFFBIGINTBINARYBITBITMAP
BLOBBLOCK* BOOLBOOLEAN* BOTHBRANCHBREADTH* BREAK* BSTRING
BTREEBUFFERBUILDBULK* BYBYDAYBYHOURBYMINUTEBYMONTHBYMONTHDAY
BYSECOND* BYTEBYWEEKNOBYYEARDAY
C
CACHECALCULATE* CALLCASCADECASCADED* CASE* CASTCATALOG
* CATCHCHAIN* CHARCHARACTERCHARACTERISTICS* CHECKCIPHER* CLASS
CLOBCLOSE* CLUSTER* CLUSTERBTRCOLLATE* COLLATIONCOLLECT* COLUMN
COLUMNS* COMMENT* COMMITCOMMITTED* COMMITWORKCOMPILECOMPLETE
COMPRESSCOMPRESSEDCONDITIONAL* CONNECTCONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF* CONNECT_BY_ROOTCONNECT_IDLE_TIMECONNECT_TIME
* CONSTCONSTANT* CONSTRAINTCONSTRAINTSCONSTRUCTOR* CONTAINS*
CONTEXT* CONTINUE* CONVERTCOPY* CORRESPONDINGCORRUPTCOUNT
COUNTERCPU_PER_CALLCPU_PER_SESSION* CREATE* CROSS* CRYPTOCTLFILE
* CUBECUMULATIVE* CURRENTCURRENT_SCHEMACURRENT_USER* CURSOR
CYCLE
D
DAILYDANGLINGDATADATABASEDATAFILEDATE* DATEADD* DATEDIFF
* DATEPARTDATETIMEDAYDBFILEDDLDDL_CLONEDEBUGDEC* DECIMAL
* DECLARE* DECODE* DEFAULTDEFERRABLEDEFERREDDEFINER* DELETE
DELETINGDELIMITEDDELTADEMANDDENSE_RANKDEPTHDEREF* DESCDETACH
DETERMINISTICDEVICEDIAGNOSTICSDICTIONARYDIRECTORY* DISABLE
DISCONNECT* DISKSPACE* DISTINCT* DISTRIBUTED* DO* DOMAIN* DOUBLE
DOWN* DROPDUMP
E

EACH* ELSE* ELSEIF* ELSIFEMPTY* ENABLEENCRYPTENCRYPTION
* END* EQUERRORERRORSESCAPEEVENTINFOEVENTSEXCEPTEXCEPTION
EXCEPTIONSEXCEPTION_INIT* EXCHANGEEXCLUDEEXCLUDINGEXCLUSIVE*
EXEC* EXECUTE* EXISTS* EXIT* EXPLAINEXTENDS* EXTERNEXTERNAL
EXTERNALLY* EXTRACT
F
FAILED_LOGIN_ATTEMPSFASTFEB* FETCHFIELDSFILEFILEGROUP
FILESIZEFILLFACTOR* FINAL* FINALLY* FIRST* FLOATFOLLOWING*
FORFORALLFORCE* FOREIGNFORMATFREQFREQUENCEFRI* FROM* FULL
* FULLY* FUNCTION
G
* GETGLOBALGLOBALLY* GOTO* GRANT* GROUP* GROUPING
H
HASH* HAVINGHEXTORAWHOLDHOURHOURLYHUGE
I
IDENTIFIED* IDENTITYIDENTITY_INSERT* IFIMAGE* IMMEDIATE*
ININCLUDEINCLUDINGINCREASEINCREMENT* INDEXINDEXESINDICES
INITIALINITIALIZEDINITIALLY* INLINE* INNERINNERIDINPUT
INSENSITIVE* INSERTINSERTINGINSTANTIABLEINSTEAD* INTINTEGER
INTENT* INTERSECT* INTERVAL* INTOINVISIBLE* ISISOLATION
J
JAN* JAVAJOB* JOINJSON* JSON_QUERY* JSON_VALUEJULJUN
K
* KEEPKEYKEYS
L
LABELLARGELASTLAX* LEADING* LEFTLESSLEVELLEXER* LIKE
LIMIT* LINK* LIST* LNNVLLOBLOCALLOCALLYLOCATIONLOCKLOCKED
LOGLOGFILELOGGINGLOGIC* LOGINLOGOFFLOGONLOGOUTLONG
LONGVARBINARYLONGVARCHAR* LOOPLSN
M
MANUALMAPMAPPEDMARMATCHMATCHEDMATERIALIZEDMAXMAXPIECESIZE
MAXSIZEMAXVALUEMAX_RUN_DURATIONMAY* MEMBERMEMORYMEM_SPACE
MERGEMINMINEXTENTS* MINUSMINUTEMINUTELYMINVALUEMIRRORMOD
MODEMODIFYMONMONEYMONITORINGMONTHMONTHLYMOUNTMOVEMENT*
MULTISET
N
NATIONAL* NATURALNCHARNCHARACTERNEVER* NEW* NEXTNO
NOARCHIVELOGNOAUDITNOBRANCHNOCACHE* NOCOPY* NOCYCLENODE
NOLOGGINGNOMAXVALUENOMINVALUENOMONITORINGNONENOORDERNORMAL
NOROWDEPENDENCIESNOSORT* NOTNOT_ALLOW_DATETIMENOT_ALLOW_IPNOV
NOWAIT* NULLNULLSNUMBERNUMERIC
O
* OBJECTOCT* OFOFFOFFLINEOFFSETOLD* ONONCEONLINEONLY
OPENOPTIMIZEOPTION* OR* ORDER* OUTOUTER* OVEROVERLAPS* OVERLAY

* OVERRIDEOVERRIDING
P
PACKAGEPADPAGEPARALLELPARALLEL_ENABLEPARMSPARTIAL*
PARTITIONPARTITIONSPASSINGPASSWORD_GRACE_TIMEPASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME  PASSWORD_POLICY  PASSWORD_REUSE_MAX 
PASSWORD_REUSE_TIMEPATH* PENDANT* PERCENTPIPEPIPELINEDPIVOT
PLACINGPLS_INTEGERPRAGMAPRECEDINGPRECISIONPRESERVEPRETTY*
PRIMARY* PRINT* PRIOR* PRIVATEPRIVILEGE* PRIVILEGES* PROCEDURE
* PROTECTED* PUBLICPURGE
Q
QUERY_REWRITE_INTEGRITY
R
* RAISERANDOMLYRANGERAWTOHEXREADREADONLYREAD_PER_CALL
READ_PER_SESSIONREALREBUILD* RECORDRECORDS* REF* REFERENCE
* REFERENCES* REFERENCINGREFRESHRELATED* RELATIVERENAME* REPEAT
REPEATABLEREPLACEREPLAY* REPLICATERESIZERESTORERESTRICTRESULT
RESULT_CACHE* RETURN* RETURNING* REVERSE* REVOKE* RIGHTROLE
* ROLLBACKROLLFILE* ROLLUPROOT* ROWROWCOUNTROWDEPENDENCIES
ROWID* ROWNUM* ROWSRULE
S
SALTSAMPLESATSAVE* SAVEPOINT* SBYTE* SCHEMASCOPESCROLL
* SEALEDSEARCHSECONDSECONDLY* SECTIONSEED* SELECTSELFSENSITIVE
SEPSEQUENCESERERRSERIALIZABLESERVERSESSIONSESSION_PER_USER
* SET* SETSSHARE* SHORTSHUTDOWNSIBLINGSSIMPLESINCESIZE*
SIZEOFSKIPSMALLINTSNAPSHOT* SOMESOUNDSPACESPANSPATIALSPFILE
SPLITSQLSTANDBYSTARTUPSTATSTATEMENT* STATICSTDDEVSTORAGE
STORESTRICTSTRING* STRUCTSTYLE* SUBPARTITIONSUBPARTITIONS
SUBSTRINGSUBTYPESUCCESSFULSUMSUNSUSPEND* SWITCHSYNCSYNCHRONOUS
* SYNONYMSYSTEMSYS_CONNECT_BY_PATH
T
* TABLETABLESPACETASKTEMPLATETEMPORARYTEXTTHANTHENTHREAD
* THROWTHUTIESTIMETIMERTIMESTIMESTAMP* TIMESTAMPADD*
TIMESTAMPDIFFTIME_ZONETINYINT* TO* TOPTRACE* TRAILINGTRANSACTION
TRANSACTIONAL* TRIGGERTRIGGERS* TRIM* TRUNCATETRUNCSIZETRXID
* TRYTUETYPE* TYPEDEF* TYPEOF
U
* UINT* ULONGUNBOUNDEDUNCOMMITTEDUNCONDITIONALUNDER* UNION
* UNIQUEUNLIMITEDUNLOCKUNPIVOT* UNTILUNUSABLEUP* UPDATE
UPDATINGUSAGE* USERUSE_HASHUSE_MERGEUSE_NLUSE_NL_WITH_INDEX
* USHORT* USINGVALUE* VALUESVARBINARYVARCHARVARCHAR2VARIANCE
V
* VARRAY  VARYING  * VERIFY  VERSIONS  VERSIONS_ENDTIME 
VERSIONS_ENDTRXID  VERSIONS_OPERATION  VERSIONS_STARTTIME 
VERSIONS_STARTTRXIDVERTICAL* VIEW* VIRTUAL* VISIBLE* VOIDVSIZE

W
WAITWEDWEEKWEEKLY* WHEN* WHENEVER* WHERE* WHILE* WITH
*WITHINWITHOUTWORKWRAPPEDWRAPPERWRITE
X
XML* XMLPARSE* XMLTABLE
Y
YEAR YEARLY
Z
ZONE