DESCRIBE TABLE
DESCRIBE [TABLE] [db.]table 描述了 db 或当前使用的数据库中的表结构。
示例
描述表 monitor:
sql
DESCRIBE TABLE monitor;DESCRIBE TABLE monitor;或者
sql
DESCRIBE monitor;DESCRIBE monitor;sql
```sql
+--------+----------------------+------+------+---------------------+---------------+
| Column | Type | Key | Null | Default | Semantic Type |
+--------+----------------------+------+------+---------------------+---------------+
| host | String | PRI | YES | | TAG |
| ts | TimestampMillisecond | PRI | NO | current_timestamp() | TIMESTAMP |
| cpu | Float64 | | YES | 0 | FIELD |
| memory | Float64 | | YES | | FIELD |
+--------+----------------------+------+------+---------------------+---------------+
4 rows in set (0.00 sec)```sql
+--------+----------------------+------+------+---------------------+---------------+
| Column | Type | Key | Null | Default | Semantic Type |
+--------+----------------------+------+------+---------------------+---------------+
| host | String | PRI | YES | | TAG |
| ts | TimestampMillisecond | PRI | NO | current_timestamp() | TIMESTAMP |
| cpu | Float64 | | YES | 0 | FIELD |
| memory | Float64 | | YES | | FIELD |
+--------+----------------------+------+------+---------------------+---------------+
4 rows in set (0.00 sec)结果中展示相应的表结构：
Column: 列名Type: 列类型Key:PRI表示该列在PRIMARY KEY约束里。Null:YES表示可以为空，否则为NODefault: 列的默认值Semantic Type：该列的语义类型，对应数据模型中的TAG、FIELD或TIMESTAMP。