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>

Parameter	Description
`<table_name>`	The name of the table to be described.

The following lists all columns and data types for the table named players:

DESCRIBE prices

Returns:

table_name	column_name	data_type
players	agecategory	TEXT
players	email	INTEGER
players	nickname	TEXT

⌘I