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>
Parameters
| Parameter | Description |
|---|---|
<table_name> | The name of the table to be described. |
Example
The following lists all columns and data types for the table named players:
DESCRIBE prices
Returns:
| table_name | column_name | data_type | nullable |
|---|---|---|---|
| players | agecategory | TEXT | 0 |
| players | INTEGER | 0 | |
| players | nickname | TEXT | 0 |