达梦数据库关键字大全(关键字不区分大小写)

注:仅对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