This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

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 |
+------------+-------------+-----------+----------+