20-keywords.md 3.1 KB
Newer Older
1
---
2
title: Reserved Keywords
D
danielclow 已提交
3 4
sidebar_label: Reserved Keywords
description: This document describes the reserved keywords in TDengine that cannot be used in object names.
5 6
---

7
## Keyword List
8

9 10 11
There are more than 200 keywords reserved by TDengine, they can't be used as the name of database, table, STable, subtable, column or tag with either upper case, lower case or mixed case. If you need to use these keywords, use the symbol `` ` `` to enclose the keywords, e.g. \`ADD\`.

The following list shows all reserved keywords:
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

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

### E

103 104
- EACH
- ENABLE
105
- END
106
- EVERY
107
- EXISTS
108
- EXPIRED
109
- EXPLAIN
110 111 112

### F

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

### G

126
- GLOB
127
- GRANT
128
- GRANTS
129
- GROUP
130 131 132

### H

133
- HAVING
134 135 136 137 138

### I

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

### J

- JOIN
159
- JSON
160 161 162 163

### K

- KEEP
164
- KEY
165 166 167 168
- KILL

### L

169 170 171
- LAST
- LAST_ROW
- LICENCES
172 173
- LIKE
- LIMIT
174
- LINEAR
175
- LOCAL
176 177 178

### M

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

### N

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

### O

205
- OF
206
- OFFSET
207
- ON
208 209
- OR
- ORDER
210
- OUTPUTTYPE
211 212 213

### P

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

### Q

227 228
- QNODE
- QNODES
229
- QTIME
230
- QUERIES
231
- QUERY
232 233 234

### R

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

### S

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

### T

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

### U

309 310 311 312 313 314 315
- UNION
- UNSIGNED
- UPDATE
- USE
- USER
- USERS
- USING
316 317 318

### V

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

### W

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

343 344 345
### \_

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