Reserved Keywords

Reserved Keywords

Currently, TDengine has over 200 internal reserved keywords. These keywords, if needed as names for databases, tables, supertables, subtables, data columns, and tag columns, regardless of case, must be enclosed with the ` symbol, such as `ADD`.

The list of keywords is as follows:

A

Keyword	Description
ABORT
ACCOUNT
ACCOUNTS
ADD
AFTER
AGGREGATE
ALIAS
ALIVE
ALL
ALTER
ANALYZE	Version 3.3.4.3 and later
AND
ANODE	Version 3.3.4.3 and later
ANODES	Version 3.3.4.3 and later
ANOMALY_WINDOW	Version 3.3.4.3 and later
ANTI
APPS
ARBGROUPS
ARROW
AS
ASC
ASOF
AT_ONCE
ATTACH

B

Keyword	Description
BALANCE
BEFORE
BEGIN
BETWEEN
BIGINT
BIN
BINARY
BITAND
BITAND
BITNOT
BITOR
BLOB
BLOCKS
BNODE
BNODES
BOOL
BOTH
BUFFER
BUFSIZE
BWLIMIT
BY

C

Keyword	Description
CACHE
CACHEMODEL
CACHESIZE
CASE
CAST
CHANGE
CHILD
CLIENT_VERSION
CLUSTER
COLON
COLUMN
COMMA
COMMENT
COMP
COMPACT
COMPACTS
CONCAT
CONFLICT
CONNECTION
CONNECTIONS
CONNS
CONSUMER
CONSUMERS
CONTAINS
COPY
COUNT
COUNT_WINDOW
CREATE
CREATEDB
CURRENT_USER

D

Keyword	Description
DATABASE
DATABASES
DBS
DECIMAL
DEFERRED
DELETE
DELETE_MARK
DELIMITERS
DESC
DESCRIBE
DETACH
DISTINCT
DISTRIBUTED
DIVIDE
DNODE
DNODES
DOT
DOUBLE
DROP
DURATION

E

Keyword	Description
EACH
ELSE
ENABLE
ENCRYPT_ALGORITHM
ENCRYPT_KEY
ENCRYPTIONS
END
EQ
EVENT_WINDOW
EVERY
EXCEPT
EXISTS
EXPIRED
EXPLAIN

F

Keyword	Description
FAIL
FHIGH	Version 3.3.4.3 and later
FILE
FILL
FILL_HISTORY
FIRST
FLOAT
FLOW	Version 3.3.4.3 and later
FLUSH
FOR
FORCE
FORCE_WINDOW_CLOSE	Version 3.3.4.3 and later
FROM
FROWTS	Version 3.3.4.3 and later
FULL
FUNCTION
FUNCTIONS

G

Keyword	Description
GE
GEOMETRY
GLOB
GRANT
GRANTS
GROUP
GT

H

Keyword	Description
HAVING
HEX
HOST

I

Keyword	Description
ID
IF
IGNORE
ILLEGAL
IMMEDIATE
IMPORT
IN
INDEX
INDEXES
INITIALLY
INNER
INSERT
INSTEAD
INT
INTEGER
INTERSECT
INTERVAL
INTO
IPTOKEN
IROWTS
IS
IS_IMPORT
ISFILLED
ISNULL

J

Keyword	Description
JLIMIT
JOIN
JSON

K

Keyword	Description
KEEP
KEEP_TIME_OFFSET
KEY
KILL

L

Keyword	Description
LANGUAGE
LAST
LAST_ROW
LE
LEADER
LEADING
LEFT
LICENCES
LIKE
LIMIT
LINEAR
LOCAL
LOGS
LP
LSHIFT
LT

M

Keyword	Description
MACHINES
MATCH
MAX_DELAY
MAXROWS
MEDIUMBLOB
MERGE
META
MINROWS
MINUS
MNODE
MNODES
MODIFY
MODULES

N

Keyword	Description
NCHAR
NE
NEXT
NMATCH
NONE
NORMAL
NOT
NOTNULL
NOW
NULL
NULL_F
NULLS

O

Keyword	Description
OF
OFFSET
ON
ONLY
OR
ORDER
OUTER
OUTPUTTYPE

P

Keyword	Description
PAGES
PAGESIZE
PARTITION
PASS
PAUSE
PI
PLUS
PORT
POSITION
PPS
PRECISION
PREV
PRIMARY
PRIVILEGE
PRIVILEGES

Q

Keyword	Description
QDURATION
QEND
QNODE
QNODES
QSTART
QTAGS
QTIME
QUERIES
QUERY
QUESTION

R

Keyword	Description
RAISE
RAND
RANGE
RATIO
READ
RECURSIVE
REDISTRIBUTE
REM
REPLACE
REPLICA
RESET
RESTORE
RESTRICT
RESUME
RETENTIONS
REVOKE
RIGHT
ROLLUP
ROW
ROWTS
RP
RSHIFT

S

Keyword	Description
S3_CHUNKPAGES
S3_COMPACT
S3_KEEPLOCAL
SCHEMALESS
SCORES
SELECT
SEMI
SERVER_STATUS
SERVER_VERSION
SESSION
SET
SHOW
SINGLE_STABLE
SLASH
SLIDING
SLIMIT
SMA
SMALLINT
SMIGRATE
SNODE
SNODES
SOFFSET
SPLIT
STABLE
STABLES
STAR
START
STATE
STATE_WINDOW
STATEMENT
STORAGE
STREAM
STREAMS
STRICT
STRING
STT_TRIGGER
SUBSCRIBE
SUBSCRIPTIONS
SUBSTR
SUBSTRING
SUBTABLE
SYSINFO
SYSTEM

T

Keyword	Description
TABLE
TABLE_PREFIX
TABLE_SUFFIX
TABLES
tag
TAGS
TBNAME
THEN
TIMES
TIMESTAMP
TIMEZONE
TINYINT
TO
TODAY
TOPIC
TOPICS
TRAILING
TRANSACTION
TRANSACTIONS
TRIGGER
TRIM
TSDB_PAGESIZE
TSERIES
TSMA
TSMAS
TTL

U

Keyword	Description
UNION
UNSAFE
UNSIGNED
UNTREATED
UPDATE
USE
USER
USERS
USING

V

Keyword	Description
VALUE
VALUE_F
VALUES
VARBINARY
VARCHAR
VARIABLE
VARIABLES
VERBOSE
VGROUP
VGROUPS
VIEW
VIEWS
VNODE
VNODES

W

Keyword	Description
WAL
WAL_FSYNC_PERIOD
WAL_LEVEL
WAL_RETENTION_PERIOD
WAL_RETENTION_SIZE
WAL_ROLL_PERIOD
WAL_SEGMENT_SIZE
WATERMARK
WDURATION
WEND
WHEN
WHERE
WINDOW
WINDOW_CLOSE
WINDOW_OFFSET
WITH
WRITE
WSTART

_

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