Reserved Keywords

Reserved Keywords

Currently, TDengine has over 200 internal reserved keywords. If you need to use these keywords as database names, table names, supertable names, subtable names, data column names, or tag column names, regardless of their case, you must enclose them with the symbol `. For example, `ADD`.

The list of keywords is as follows:

A

• ABORT
• ACCOUNT
• ACCOUNTS
• ADD
• AFTER
• AGGREGATE
• ALIVE
• ALL
• ALTER
• ANALYZE
• AND
• APPS
• AS
• ASC
• AT_ONCE
• ATTACH

B

• BALANCE
• BEFORE
• BEGIN
• BETWEEN
• BIGINT
• BINARY
• BITAND
• BITNOT
• BITOR
• BLOCKS
• BNODE
• BNODES
• BOOL
• BUFFER
• BUFSIZE
• BY

C

• CACHE
• CACHEMODEL
• CACHESIZE
• CASCADE
• CAST
• CHANGE
• CLIENT_VERSION
• CLUSTER
• COLON
• COLUMN
• COMMA
• COMMENT
• COMP
• COMPACT
• CONCAT
• CONFLICT
• CONNECTION
• CONNECTIONS
• CONNS
• CONSUMER
• CONSUMERS
• CONTAINS
• COPY
• COUNT
• CREATE
• CURRENT_USER

D

• DATABASE
• DATABASES
• DBS
• DEFERRED
• DELETE
• DELIMITERS
• DESC
• DESCRIBE
• DETACH
• DISTINCT
• DISTRIBUTED
• DIVIDE
• DNODE
• DNODES
• DOT
• DOUBLE
• DROP
• DURATION

E

• EACH
• ENABLE
• END
• EVERY
• EXISTS
• EXPIRED
• EXPLAIN

F

• FAIL
• FILE
• FILL
• FIRST
• FLOAT
• FLUSH
• FOR
• FROM
• FUNCTION
• FUNCTIONS

G

• GLOB
• GRANT
• GRANTS
• GROUP

H

• HAVING
• HOST

I

• ID
• IF
• IGNORE
• IMMEDIATE
• IMPORT
• IN
• INDEX
• INDEXES
• INITIALLY
• INNER
• INSERT
• INSTEAD
• INT
• INTEGER
• INTERVAL
• INTO
• IS
• IS NULL

J

• JOIN
• JSON

K

• KEEP
• KEY
• KILL

L

• LAST
• LAST_ROW
• LICENCES
• LIKE
• LIMIT
• LINEAR
• LOCAL

M

• MATCH
• MAX_DELAY
• BWLIMIT
• MAXROWS
• MAX_SPEED
• MERGE
• META
• MINROWS
• MINUS
• MNODE
• MNODES
• MODIFY
• MODULES

N

• NCHAR
• NEXT
• NMATCH
• NONE
• NOT
• NOT NULL
• NOW
• NULL
• NULLS

O

• OF
• OFFSET
• ON
• OR
• ORDER
• OUTPUTTYPE

P

• PAGES
• PAGESIZE
• PARTITIONS
• PASS
• PLUS
• PORT
• PPS
• PRECISION
• PREV
• PRIVILEGE

Q

• QNODE
• QNODES
• QTIME
• QUERIES
• QUERY

R

• RAISE
• RANGE
• RATIO
• READ
• REDISTRIBUTE
• RENAME
• REPLACE
• REPLICA
• RESET
• RESTRICT
• RETENTIONS
• REVOKE
• ROLLUP
• ROW

S

• SCHEMALESS
• SCORES
• SELECT
• SEMI
• SERVER_STATUS
• SERVER_VERSION
• SESSION
• SET
• SHOW
• SINGLE_STABLE
• SLIDING
• SLIMIT
• SMA
• SMALLINT
• SNODE
• SNODES
• SOFFSET
• SPLIT
• STABLE
• STABLES
• START
• STATE
• STATE_WINDOW
• STATEMENT
• STORAGE
• STREAM
• STREAMS
• STRICT
• STRING
• SUBSCRIPTIONS
• SYNCDB
• SYSINFO

T

• TABLE
• TABLES
• TAG
• TAGS
• TBNAME
• TIMES
• TIMESTAMP
• TIMEZONE
• TINYINT
• TO
• TODAY
• TOPIC
• TOPICS
• TRANSACTION
• TRANSACTIONS
• TRIGGER
• TRIM
• TSERIES
• TTL

U

• UNION
• UNSIGNED
• UPDATE
• USE
• USER
• USERS
• USING

V

• VALUE
• VALUES
• VARCHAR
• VARIABLE
• VARIABLES
• VERBOSE
• VGROUP
• VGROUPS
• VIEW
• VNODES

W

• WAL
• WAL_FSYNC_PERIOD
• WAL_LEVEL
• WAL_RETENTION_PERIOD
• WAL_RETENTION_SIZE
• WATERMARK
• WHERE
• WINDOW_CLOSE
• WITH
• WRITE

_

• _C0
• _IROWTS
• _QDURATION
• _QEND
• _QSTART
• _ROWTS
• _WDURATION
• _WEND
• _WSTART