20-keywords.md 3.1 KB
Newer Older
G
gccgdb1234 已提交
1
---
G
gccgdb1234 已提交
2
sidebar_label: 保留关键字
G
gccgdb1234 已提交
3
title: 保留关键字
4
description: TDengine 保留关键字的详细列表
G
gccgdb1234 已提交
5 6 7 8
---

## 保留关键字

9 10
目前 TDengine 有 200 多个内部保留关键字,这些关键字如果需要用作库名、表名、超级表名、子表名、数据列名及标签列名等,无论大小写,需要使用符号 `` ` `` 将关键字括起来使用,例如 \`ADD\`

D
dapan1121 已提交
11
关键字列表如下:
G
gccgdb1234 已提交
12

13 14 15 16 17 18 19
### A

- ABORT
- ACCOUNT
- ACCOUNTS
- ADD
- AFTER
20
- AGGREGATE
A
Alex Duan 已提交
21
- ALIVE
22 23
- ALL
- ALTER
24
- ANALYZE
25
- AND
26
- APPS
27 28
- AS
- ASC
29
- AT_ONCE
30 31 32 33
- ATTACH

### B

34
- BALANCE
35 36 37 38 39 40 41 42 43
- BEFORE
- BEGIN
- BETWEEN
- BIGINT
- BINARY
- BITAND
- BITNOT
- BITOR
- BLOCKS
44 45
- BNODE
- BNODES
46
- BOOL
47 48
- BUFFER
- BUFSIZE
49 50 51 52 53
- BY

### C

- CACHE
54 55
- CACHEMODEL
- CACHESIZE
56
- CASCADE
57
- CAST
58
- CHANGE
59
- CLIENT_VERSION
60 61 62 63
- CLUSTER
- COLON
- COLUMN
- COMMA
64
- COMMENT
65 66 67 68 69 70 71
- COMP
- COMPACT
- CONCAT
- CONFLICT
- CONNECTION
- CONNECTIONS
- CONNS
72 73 74
- CONSUMER
- CONSUMERS
- CONTAINS
75
- COPY
76
- COUNT
77
- CREATE
78
- CURRENT_USER
79 80 81

### D

G
gccgdb1234 已提交
82 83 84 85
- DATABASE
- DATABASES
- DBS
- DEFERRED
86 87
- DELETE
- DELIMITERS
G
gccgdb1234 已提交
88 89 90 91
- DESC
- DESCRIBE
- DETACH
- DISTINCT
92
- DISTRIBUTED
G
gccgdb1234 已提交
93 94 95 96 97 98
- DIVIDE
- DNODE
- DNODES
- DOT
- DOUBLE
- DROP
99
- DURATION
100 101 102

### E

103 104
- EACH
- ENABLE
G
gccgdb1234 已提交
105
- END
106
- EVERY
G
gccgdb1234 已提交
107
- EXISTS
108
- EXPIRED
G
gccgdb1234 已提交
109
- EXPLAIN
110 111 112

### F

G
gccgdb1234 已提交
113 114 115
- FAIL
- FILE
- FILL
116
- FIRST
G
gccgdb1234 已提交
117
- FLOAT
118
- FLUSH
G
gccgdb1234 已提交
119 120
- FOR
- FROM
121 122
- FUNCTION
- FUNCTIONS
123 124 125

### G

G
gccgdb1234 已提交
126
- GLOB
127
- GRANT
128
- GRANTS
G
gccgdb1234 已提交
129
- GROUP
130 131 132

### H

G
gccgdb1234 已提交
133
- HAVING
134 135 136 137 138

### I

- ID
- IF
G
gccgdb1234 已提交
139
- IGNORE
140
- IMMEDIATE
G
gccgdb1234 已提交
141 142
- IMPORT
- IN
143 144 145 146
- INDEX
- INDEXES
- INITIALLY
- INNER
G
gccgdb1234 已提交
147
- INSERT
148
- INSTEAD
G
gccgdb1234 已提交
149
- INT
150
- INTEGER
151
- INTERVAL
G
gccgdb1234 已提交
152 153 154
- INTO
- IS
- ISNULL
155 156 157 158

### J

- JOIN
159
- JSON
160 161 162 163

### K

- KEEP
G
gccgdb1234 已提交
164
- KEY
165 166 167 168
- KILL

### L

169 170 171
- LAST
- LAST_ROW
- LICENCES
G
gccgdb1234 已提交
172 173
- LIKE
- LIMIT
174
- LINEAR
G
gccgdb1234 已提交
175
- LOCAL
176 177 178

### M

G
gccgdb1234 已提交
179
- MATCH
180
- MAX_DELAY
G
gccgdb1234 已提交
181
- MAXROWS
182 183
- MERGE
- META
G
gccgdb1234 已提交
184 185
- MINROWS
- MINUS
186
- MNODE
G
gccgdb1234 已提交
187 188 189
- MNODES
- MODIFY
- MODULES
190 191 192

### N

193 194 195
- NCHAR
- NEXT
- NMATCH
G
gccgdb1234 已提交
196 197
- NONE
- NOT
198
- NOTNULL
G
gccgdb1234 已提交
199
- NOW
200
- NULL
201
- NULLS
202 203 204

### O

G
gccgdb1234 已提交
205
- OF
206
- OFFSET
207
- ON
G
gccgdb1234 已提交
208 209
- OR
- ORDER
210
- OUTPUTTYPE
211 212 213

### P

214 215 216
- PAGES
- PAGESIZE
- PARTITIONS
G
gccgdb1234 已提交
217 218
- PASS
- PLUS
219
- PORT
G
gccgdb1234 已提交
220
- PPS
221
- PRECISION
G
gccgdb1234 已提交
222
- PREV
223 224 225 226
- PRIVILEGE

### Q

227 228
- QNODE
- QNODES
G
gccgdb1234 已提交
229
- QTIME
230
- QUERIES
G
gccgdb1234 已提交
231
- QUERY
232 233 234

### R

G
gccgdb1234 已提交
235
- RAISE
236 237 238 239 240
- RANGE
- RATIO
- READ
- REDISTRIBUTE
- RENAME
241 242
- REPLACE
- REPLICA
G
gccgdb1234 已提交
243
- RESET
244 245 246 247
- RESTRICT
- RETENTIONS
- REVOKE
- ROLLUP
G
gccgdb1234 已提交
248
- ROW
249 250 251

### S

252
- SCHEMALESS
G
gccgdb1234 已提交
253 254 255
- SCORES
- SELECT
- SEMI
256 257
- SERVER_STATUS
- SERVER_VERSION
258
- SESSION
G
gccgdb1234 已提交
259 260
- SET
- SHOW
261
- SINGLE_STABLE
262
- SLIDING
G
gccgdb1234 已提交
263
- SLIMIT
264 265 266 267
- SMA
- SMALLINT
- SNODE
- SNODES
268
- SOFFSET
269 270 271
- SPLIT
- STABLE
- STABLES
G
gccgdb1234 已提交
272 273
- STAR
- STATE
274 275
- STATE_WINDOW
- STATEMENT
G
gccgdb1234 已提交
276 277 278
- STORAGE
- STREAM
- STREAMS
279
- STRICT
G
gccgdb1234 已提交
280
- STRING
281
- SUBSCRIPTIONS
G
gccgdb1234 已提交
282
- SYNCDB
283
- SYSINFO
284 285 286

### T

G
gccgdb1234 已提交
287 288 289 290 291 292 293
- TABLE
- TABLES
- TAG
- TAGS
- TBNAME
- TIMES
- TIMESTAMP
294
- TIMEZONE
G
gccgdb1234 已提交
295
- TINYINT
296 297
- TO
- TODAY
G
gccgdb1234 已提交
298 299
- TOPIC
- TOPICS
300 301
- TRANSACTION
- TRANSACTIONS
G
gccgdb1234 已提交
302
- TRIGGER
303
- TRIM
G
gccgdb1234 已提交
304
- TSERIES
D
dapan1121 已提交
305
- TTL
306 307 308

### U

G
gccgdb1234 已提交
309 310 311 312 313 314 315
- UNION
- UNSIGNED
- UPDATE
- USE
- USER
- USERS
- USING
316 317 318

### V

K
kynowoo 已提交
319
- VALUE
G
gccgdb1234 已提交
320
- VALUES
321
- VARCHAR
G
gccgdb1234 已提交
322
- VARIABLE
323
- VARIABLES
324 325
- VERBOSE
- VGROUP
G
gccgdb1234 已提交
326 327 328
- VGROUPS
- VIEW
- VNODES
329 330 331 332

### W

- WAL
333 334 335 336 337 338 339
- WAL_FSYNC_PERIOD
- WAL_LEVEL
- WAL_RETENTION_PERIOD
- WAL_RETENTION_SIZE
- WAL_ROLL_PERIOD
- WAL_SEGMENT_SIZE
- WATERMARK
340
- WHERE
341 342 343
- WINDOW_CLOSE
- WITH
- WRITE
344

G
gccgdb1234 已提交
345 346 347
### \_

- \_C0
G
Ganlin Zhao 已提交
348
- \_IROWTS
G
gccgdb1234 已提交
349
- \_QDURATION
350 351 352
- \_QEND
- \_QSTART
- \_ROWTS
G
gccgdb1234 已提交
353
- \_WDURATION
354 355
- \_WEND
- \_WSTART