Metadata commands
DESCRIBE
Reference and syntax for the DESCRIBE table command.
Lists all columns and data types for the table. Once the results are displayed, you can also export them to CSV or JSON.
Syntax
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
:
Returns:
table_name | column_name | data_type | nullable |
---|---|---|---|
players | agecategory | TEXT | 0 |
players | INTEGER | 0 | |
players | nickname | TEXT | 0 |