DESCRIBE TABLE
DESCRIBE TABLE [db.]table
describes the table structure in the db
or the current database in-use.
Examples
Describes the table monitor
:
sql
DESCRIBE TABLE monitor;
sql
+--------+----------------------+------+---------+---------------+
| Field | Type | Null | Default | Semantic Type |
+--------+----------------------+------+---------+---------------+
| host | String | YES | | PRIMARY KEY |
| ts | TimestampMillisecond | NO | | TIME INDEX |
| cpu | Float64 | YES | 0 | VALUE |
| memory | Float64 | YES | | VALUE |
+--------+----------------------+------+---------+---------------+
4 rows in set (0.00 sec)
It produces the table structure:
Field
: the column namesType
: the column typesNull
:yes
means nullable, otherwiseno
Default
: default value of the columnSemantic Type
: the semantic type of column, such asTAG
,VALUE
,TIME INDEX
orPRIMARY KEY
.