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

ParameterDescription
<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_namecolumn_namedata_typenullable
playersagecategoryTEXT0
playersemailINTEGER0
playersnicknameTEXT0