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

SHOW COLUMNS

Lists columns and their properties for a specified table. Returns <table_name>, <column_name>, <data_type>, and nullable (1 if nullable, 0 if not) for each column.

Syntax

SHOW COLUMNS <table_name>;

Example

SHOW COLUMNS prices;

Returns

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