达梦数据库关键字大全

iiiiibingo

8660人浏览 · 2022-03-29 16:21:39

iiiiibingo · 2022-03-29 16:21:39 发布

达梦数据库关键字大全（关键字不区分大小写）

注：仅对dm8.4之前版本

1	KEYWORD	LENGTH
2	ABORT	5
3	ABSOLUTE	8
4	ABSTRACT	8
5	ACCESSED	8
6	ACCOUNT	7
7	ACROSS	6
8	ACTION	6
9	ADD	3
10	ADMIN	5
11	ADVANCED	8
12	AFTER	5
13	AGGREGATE	9
14	ALL	3
15	ALLOW_DATETIME	14
16	ALLOW_IP	8
17	ALTER	5
18	ANALYZE	7
19	AND	3
20	ANY	3
21	APR	3
22	ARCHIVE	7
23	ARCHIVEDIR	10
24	ARCHIVELOG	10
25	ARCHIVESTYLE	12
26	ARRAY	5
27	ARRAYLEN	8
28	AS	2
29	ASC	3
30	ASCII	5
31	ASENSITIVE	10
32	ASSIGN	6
33	ASYNCHRONOUS	12
34	AT	2
35	ATTACH	6
36	AUDIT	5
37	AUG	3
38	AUTHID	6
39	AUTHORIZATION	13
40	AUTO	4
41	AUTOEXTEND	10
42	AUTONOMOUS_TRANSACTION	22
43	AVG	3
44	BACKED	6
45	BACKUP	6
46	BACKUPDIR	9
47	BACKUPINFO	10
48	BACKUPSET	9
49	BADFILE	7
50	BAKFILE	7
51	BASE	4
52	BATCH	5
53	BEFORE	6
54	BEGIN	5
55	BETWEEN	7
56	BIGDATEDIFF	11
57	BIGINT	6
58	BINARY	6
59	BIT	3
60	BITMAP	6
61	BLOB	4
62	BLOCK	5
63	BOOL	4
64	BOOLEAN	7
65	BOTH	4
66	BRANCH	6
67	BREADTH	7
68	BREAK	5
69	BSTRING	7
70	BTREE	5
71	BUFFER	6
72	BUILD	5
73	BULK	4
74	BY	2
75	BYDAY	5
76	BYHOUR	6
77	BYMINUTE	8
78	BYMONTH	7
79	BYMONTHDAY	10
80	BYSECOND	8
81	BYTE	4
82	BYWEEKNO	8
83	BYYEARDAY	9
84	CACHE	5
85	CALCULATE	9
86	CALL	4
87	CASCADE	7
88	CASCADED	8
89	CASE	4
90	CAST	4
91	CATALOG	7
92	CATCH	5
93	CHAIN	5
94	CHAR	4
95	CHARACTER	9
96	CHARACTERISTICS	15
97	CHECK	5
98	CIPHER	6
99	CLASS	5
100	CLOB	4
101	CLOSE	5
102	CLUSTER	7
103	CLUSTERBTR	10
104	COLLATE	7
105	COLLATION	9
106	COLLECT	7
107	COLUMN	6
108	COLUMNS	7
109	COMMENT	7
110	COMMIT	6
111	COMMITTED	9
112	COMMITWORK	10
113	COMPILE	7
114	COMPLETE	8
115	COMPRESS	8
116	COMPRESSED	10
117	CONDITIONAL	11
118	CONNECT	7
119	CONNECT_BY_ISCYCLE	18
120	CONNECT_BY_ISLEAF	17
121	CONNECT_BY_ROOT	15
122	CONNECT_IDLE_TIME	17
123	CONNECT_TIME	12
124	CONST	5
125	CONSTANT	8
126	CONSTRAINT	10
127	CONSTRAINTS	11
128	CONSTRUCTOR	11
129	CONTAINS	8
130	CONTEXT	7
131	CONTINUE	8
132	CONVERT	7
133	COPY	4
134	CORRESPONDING	13
135	CORRUPT	7
136	COUNT	5
137	COUNTER	7
138	CPU_PER_CALL	12
139	CPU_PER_SESSION	15
140	CREATE	6
141	CROSS	5
142	CRYPTO	6
143	CTLFILE	7
144	CUBE	4
145	CUMULATIVE	10
146	CURRENT	7
147	CURRENT_SCHEMA	14
148	CURRENT_USER	12
149	CURSOR	6
150	CYCLE	5
151	DAILY	5
152	DANGLING	8
153	DATA	4
154	DATABASE	8
155	DATAFILE	8
156	DATE	4
157	DATEADD	7
158	DATEDIFF	8
159	DATEPART	8
160	DATETIME	8
161	DAY	3
162	DBFILE	6
163	DDL	3
164	DDL_CLONE	9
165	DEBUG	5
166	DEC	3
167	DECIMAL	7
168	DECLARE	7
169	DECODE	6
170	DEFAULT	7
171	DEFERRABLE	10
172	DEFERRED	8
173	DEFINER	7
174	DELETE	6
175	DELETING	8
176	DELIMITED	9
177	DELTA	5
178	DEMAND	6
179	DENSE_RANK	10
180	DEPTH	5
181	DEREF	5
182	DESC	4
183	DETACH	6
184	DETERMINISTIC	13
185	DEVICE	6
186	DIAGNOSTICS	11
187	DICTIONARY	10
188	DIRECTORY	9
189	DISABLE	7
190	DISCONNECT	10
191	DISKSPACE	9
192	DISTINCT	8
193	DISTRIBUTED	11
194	DO	2
195	DOMAIN	6
196	DOUBLE	6
197	DOWN	4
198	DROP	4
199	DUMP	4
200	EACH	4
201	EDITIONABLE	11
202	ELSE	4
203	ELSEIF	6
204	ELSIF	5
205	EMPTY	5
206	ENABLE	6
207	ENCRYPT	7
208	ENCRYPTION	10
209	END	3
210	EQU	3
211	ERROR	5
212	ERRORS	6
213	ESCAPE	6
214	EVENTINFO	9
215	EVENTS	6
216	EXCEPT	6
217	EXCEPTION	9
218	EXCEPTIONS	10
219	EXCEPTION_INIT	14
220	EXCHANGE	8
221	EXCLUDE	7
222	EXCLUDING	9
223	EXCLUSIVE	9
224	EXEC	4
225	EXECUTE	7
226	EXISTS	6
227	EXIT	4
228	EXPLAIN	7
229	EXTENDS	7
230	EXTERN	6
231	EXTERNAL	8
232	EXTERNALLY	10
233	EXTRACT	7
234	FAILED_LOGIN_ATTEMPS	20
235	FAST	4
236	FEB	3
237	FETCH	5
238	FIELDS	6
239	FILE	4
240	FILEGROUP	9
241	FILESIZE	8
242	FILLFACTOR	10
243	FINAL	5
244	FINALLY	7
245	FIRST	5
246	FLOAT	5
247	FOLLOWING	9
248	FOR	3
249	FORALL	6
250	FORCE	5
251	FOREIGN	7
252	FORMAT	6
253	FREQ	4
254	FREQUENCE	9
255	FRI	3
256	FROM	4
257	FULL	4
258	FULLY	5
259	FUNCTION	8
260	GET	3
261	GLOBAL	6
262	GLOBALLY	8
263	GOTO	4
264	GRANT	5
265	GREAT	5
266	GROUP	5
267	GROUPING	8
268	HASH	4
269	HASHPARTMAP	11
270	HAVING	6
271	HEXTORAW	8
272	HOLD	4
273	HOUR	4
274	HOURLY	6
275	HUGE	4
276	IDENTIFIED	10
277	IDENTITY	8
278	IDENTITY_INSERT	15
279	IF	2
280	IFNULL	6
281	IGNORE_ROW_ON_DUPKEY_INDEX	26
282	IMAGE	5
283	IMMEDIATE	9
284	IN	2
285	INCLUDE	7
286	INCLUDING	9
287	INCREASE	8
288	INCREMENT	9
289	INDEX	5
290	INDEXES	7
291	INDICES	7
292	INITIAL	7
293	INITIALIZED	11
294	INITIALLY	9
295	INLINE	6
296	INNER	5
297	INNERID	7
298	INPUT	5
299	INSENSITIVE	11
300	INSERT	6
301	INSERTING	9
302	INSTANCE	8
303	INSTANTIABLE	12
304	INSTEAD	7
305	INT	3
306	INTEGER	7
307	INTENT	6
308	INTERSECT	9
309	INTERVAL	8
310	INTO	4
311	INVISIBLE	9
312	IS	2
313	ISOLATION	9
314	JAN	3
315	JAVA	4
316	JOB	3
317	JOIN	4
318	JSON	4
319	JUL	3
320	JUN	3
321	KEEP	4
322	KEY	3
323	KEYS	4
324	LABEL	5
325	LARGE	5
326	LAST	4
327	LAX	3
328	LEADING	7
329	LEFT	4
330	LESS	4
331	LEVEL	5
332	LEXER	5
333	LIKE	4
334	LIMIT	5
335	LINK	4
336	LIST	4
337	LNNVL	5
338	LOB	3
339	LOCAL	5
340	LOCALLY	7
341	LOCAL_OBJECT	12
342	LOCATION	8
343	LOCK	4
344	LOCKED	6
345	LOG	3
346	LOGFILE	7
347	LOGGING	7
348	LOGIN	5
349	LOGOFF	6
350	LOGON	5
351	LOGOUT	6
352	LONG	4
353	LONGVARBINARY	13
354	LONGVARCHAR	11
355	LOOP	4
356	LSN	3
357	MANUAL	6
358	MAP	3
359	MAPPED	6
360	MAR	3
361	MATCH	5
362	MATCHED	7
363	MATERIALIZED	12
364	MAX	3
365	MAXPIECESIZE	12
366	MAXSIZE	7
367	MAXVALUE	8
368	MAX_RUN_DURATION	16
369	MAY	3
370	MEMBER	6
371	MEMORY	6
372	MEM_SPACE	9
373	MERGE	5
374	MICRO	5
375	MIN	3
376	MINEXTENTS	10
377	MINUS	5
378	MINUTE	6
379	MINUTELY	8
380	MINVALUE	8
381	MIRROR	6
382	MOD	3
383	MODE	4
384	MODIFY	6
385	MON	3
386	MONEY	5
387	MONITORING	10
388	MONTH	5
389	MONTHLY	7
390	MOUNT	5
391	MOVE	4
392	MOVEMENT	8
393	MULTISET	8
394	NATIONAL	8
395	NATURAL	7
396	NCHAR	5
397	NCHARACTER	10
398	NEVER	5
399	NEW	3
400	NEXT	4
401	NO	2
402	NOARCHIVELOG	12
403	NOAUDIT	7
404	NOBRANCH	8
405	NOCACHE	7
406	NOCOPY	6
407	NOCYCLE	7
408	NODE	4
409	NOLOGGING	9
410	NOMAXVALUE	10
411	NOMINVALUE	10
412	NOMONITORING	12
413	NONE	4
414	NONEDITIONABLE	14
415	NOORDER	7
416	NORMAL	6
417	NOROWDEPENDENCIES	17
418	NOSORT	6
419	NOT	3
420	NOT_ALLOW_DATETIME	18
421	NOT_ALLOW_IP	12
422	NOV	3
423	NOWAIT	6
424	NULL	4
425	NULLS	5
426	NUMBER	6
427	NUMERIC	7
428	OBJECT	6
429	OCT	3
430	OF	2
431	OFF	3
432	OFFLINE	7
433	OFFSET	6
434	OLD	3
435	ON	2
436	ONCE	4
437	ONLINE	6
438	ONLY	4
439	OPEN	4
440	OPTIMIZE	8
441	OPTION	6
442	OR	2
443	ORDER	5
444	OUT	3
445	OUTER	5
446	OVER	4
447	OVERLAPS	8
448	OVERLAY	7
449	OVERRIDE	8
450	OVERRIDING	10
451	PACKAGE	7
452	PAD	3
453	PAGE	4
454	PARALLEL	8
455	PARALLEL_ENABLE	15
456	PARMS	5
457	PARTIAL	7
458	PARTITION	9
459	PARTITIONS	10
460	PASSING	7
461	PASSWORD_GRACE_TIME	19
462	PASSWORD_LIFE_TIME	18
463	PASSWORD_LOCK_TIME	18
464	PASSWORD_POLICY	15
465	PASSWORD_REUSE_MAX	18
466	PASSWORD_REUSE_TIME	19
467	PATH	4
468	PENDANT	7
469	PERCENT	7
470	PIPE	4
471	PIPELINED	9
472	PIVOT	5
473	PLACING	7
474	PLS_INTEGER	11
475	PRAGMA	6
476	PRECEDING	9
477	PRECISION	9
478	PRESERVE	8
479	PRETTY	6
480	PRIMARY	7
481	PRINT	5
482	PRIOR	5
483	PRIVATE	7
484	PRIVILEGE	9
485	PRIVILEGES	10
486	PROCEDURE	9
487	PROFILE	7
488	PROTECTED	9
489	PUBLIC	6
490	PURGE	5
491	QUERY_REWRITE_INTEGRITY	23
492	RAISE	5
493	RANDOMLY	8
494	RANGE	5
495	RAWTOHEX	8
496	READ	4
497	READONLY	8
498	READ_PER_CALL	13
499	READ_PER_SESSION	16
500	REAL	4
501	REBUILD	7
502	RECORD	6
503	RECORDS	7
504	REF	3
505	REFERENCE	9
506	REFERENCES	10
507	REFERENCING	11
508	REFRESH	7
509	REJECT	6
510	RELATED	7
511	RELATIVE	8
512	RENAME	6
513	REPEAT	6
514	REPEATABLE	10
515	REPLACE	7
516	REPLAY	6
517	REPLICATE	9
518	RESIZE	6
519	RESTORE	7
520	RESTRICT	8
521	RESTRICT_REFERENCES	19
522	RESULT	6
523	RESULT_CACHE	12
524	RETURN	6
525	RETURNING	9
526	REVERSE	7
527	REVOKE	6
528	RIGHT	5
529	ROLE	4
530	ROLLBACK	8
531	ROLLFILE	8
532	ROLLUP	6
533	ROOT	4
534	ROW	3
535	ROWCOUNT	8
536	ROWDEPENDENCIES	15
537	ROWID	5
538	ROWNUM	6
539	ROWS	4
540	RULE	4
541	SALT	4
542	SAMPLE	6
543	SAT	3
544	SAVE	4
545	SAVEPOINT	9
546	SBYTE	5
547	SCHEMA	6
548	SCOPE	5
549	SCROLL	6
550	SEALED	6
551	SEARCH	6
552	SECOND	6
553	SECONDLY	8
554	SECTION	7
555	SEED	4
556	SELECT	6
557	SELF	4
558	SENSITIVE	9
559	SEP	3
560	SEQUENCE	8
561	SERERR	6
562	SERIALIZABLE	12
563	SERVER	6
564	SESSION	7
565	SESSION_PER_USER	16
566	SET	3
567	SETS	4
568	SHARE	5
569	SHORT	5
570	SHUTDOWN	8
571	SIBLINGS	8
572	SIMPLE	6
573	SINCE	5
574	SIZE	4
575	SIZEOF	6
576	SKIP	4
577	SMALLINT	8
578	SNAPSHOT	8
579	SOME	4
580	SOUND	5
581	SPACE	5
582	SPAN	4
583	SPATIAL	7
584	SPEED	5
585	SPFILE	6
586	SPLIT	5
587	SQL	3
588	STANDBY	7
589	STARTUP	7
590	STAT	4
591	STATEMENT	9
592	STATIC	6
593	STDDEV	6
594	STOP	4
595	STORAGE	7
596	STORE	5
597	STRICT	6
598	STRING	6
599	STRUCT	6
600	STYLE	5
601	SUBPARTITION	12
602	SUBPARTITIONS	13
603	SUBSTRING	9
604	SUBTYPE	7
605	SUCCESSFUL	10
606	SUM	3
607	SUN	3
608	SUSPEND	7
609	SWITCH	6
610	SYNC	4
611	SYNCHRONOUS	11
612	SYNONYM	7
613	SYSTEM	6
614	SYS_CONNECT_BY_PATH	19
615	TABLE	5
616	TABLESPACE	10
617	TASK	4
618	TEMPLATE	8
619	TEMPORARY	9
620	TEXT	4
621	THAN	4
622	THEN	4
623	THREAD	6
624	THROUGH	7
625	THROW	5
626	THU	3
627	TIES	4
628	TIME	4
629	TIMER	5
630	TIMES	5
631	TIMESTAMP	9
632	TIMESTAMPADD	12
633	TIMESTAMPDIFF	13
634	TIME_ZONE	9
635	TINYINT	7
636	TO	2
637	TOP	3
638	TRACE	5
639	TRAILING	8
640	TRANSACTION	11
641	TRANSACTIONAL	13
642	TRIGGER	7
643	TRIGGERS	8
644	TRIM	4
645	TRUNCATE	8
646	TRUNCSIZE	9
647	TRXID	5
648	TRY	3
649	TUE	3
650	TYPE	4
651	TYPEDEF	7
652	TYPEOF	6
653	UINT	4
654	ULONG	5
655	UNBOUNDED	9
656	UNCOMMITTED	11
657	UNCONDITIONAL	13
658	UNDER	5
659	UNION	5
660	UNIQUE	6
661	UNLIMITED	9
662	UNLOCK	6
663	UNPIVOT	7
664	UNTIL	5
665	UNUSABLE	8
666	UP	2
667	UPDATE	6
668	UPDATING	8
669	USAGE	5
670	USER	4
671	USE_HASH	8
672	USE_MERGE	9
673	USE_NL	6
674	USE_NL_WITH_INDEX	17
675	USHORT	6
676	USING	5
677	VALUE	5
678	VALUES	6
679	VARBINARY	9
680	VARCHAR	7
681	VARCHAR2	8
682	VARIANCE	8
683	VARRAY	6
684	VARYING	7
685	VERIFY	6
686	VERSIONS	8
687	VERSIONS_ENDTIME	16
688	VERSIONS_ENDTRXID	17
689	VERSIONS_OPERATION	18
690	VERSIONS_STARTTIME	18
691	VERSIONS_STARTTRXID	19
692	VERTICAL	8
693	VIEW	4
694	VIRTUAL	7
695	VISIBLE	7
696	VOID	4
697	VSIZE	5
698	WAIT	4
699	WED	3
700	WEEK	4
701	WEEKLY	6
702	WHEN	4
703	WHENEVER	8
704	WHERE	5
705	WHILE	5
706	WITH	4
707	WITHIN	6
708	WITHOUT	7
709	WORK	4
710	WRAPPED	7
711	WRAPPER	7
712	WRITE	5
713	XML	3
714	XMLAGG	6
715	XMLPARSE	8
716	XMLTABLE	8
717	YEAR	4
718	YEARLY	6
719	ZONE	4