Skip to main content

DESCRIBE TABLE

Displays information about the columns in a given table.

Syntax

DESC|DESCRIBE [database.]table_name

Examples

DESC system.one;
+-------+------------------+------+---------+
| Field | Type | Null | Default |
+-------+------------------+------+---------+
| dummy | TINYINT UNSIGNED | NO | 0 |
+-------+------------------+------+---------+