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