Link Search Menu Expand Document

DESCRIBE

Lists all columns and data types for the table. Once the results are displayed, you can also export them to CSV or JSON.

Syntax

DESCRIBE <table_name>

Example

The following lists all columns and data types for the table named prices:

DESCRIBE prices

Returns:

+------------+-------------+-----------+----------+
| table_name | column_name | data_type | nullable |
+------------+-------------+-----------+----------+
| prices     | item        | TEXT      |        0 |
| prices     | num         | INTEGER   |        0 |
+------------+-------------+-----------+----------+