Skip to main content

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

KeywordDescription
ABORT
ACCOUNT
ACCOUNTS
ADD
AFTER
AGGREGATE
ALIAS
ALIVE
ALL
ALTER
ANALYZEVersion 3.3.4.3 and later
AND
ANODEVersion 3.3.4.3 and later
ANODESVersion 3.3.4.3 and later
ANOMALY_WINDOWVersion 3.3.4.3 and later
ANTI
APPS
ARBGROUPS
ARROW
AS
ASC
ASOF
AT_ONCE
ATTACH

B

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

C

KeywordDescription
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

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

E

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

F

KeywordDescription
FAIL
FHIGHVersion 3.3.4.3 and later
FILE
FILL
FILL_HISTORY
FIRST
FLOAT
FLOWVersion 3.3.4.3 and later
FLUSH
FOR
FORCE
FORCE_WINDOW_CLOSEVersion 3.3.4.3 and later
FROM
FROWTSVersion 3.3.4.3 and later
FULL
FUNCTION
FUNCTIONS

G

KeywordDescription
GE
GEOMETRY
GLOB
GRANT
GRANTS
GROUP
GT

H

KeywordDescription
HAVING
HEX
HOST

I

KeywordDescription
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

KeywordDescription
JLIMIT
JOIN
JSON

K

KeywordDescription
KEEP
KEEP_TIME_OFFSET
KEY
KILL

L

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

M

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

N

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

O

KeywordDescription
OF
OFFSET
ON
ONLY
OR
ORDER
OUTER
OUTPUTTYPE

P

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

Q

KeywordDescription
QDURATION
QEND
QNODE
QNODES
QSTART
QTAGS
QTIME
QUERIES
QUERY
QUESTION

R

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

S

KeywordDescription
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

KeywordDescription
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

KeywordDescription
UNION
UNSAFE
UNSIGNED
UNTREATED
UPDATE
USE
USER
USERS
USING

V

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

W

KeywordDescription
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