> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the DESCRIBE table command.

# 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

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
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`:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
DESCRIBE prices
```

**Returns:**

| table\_name | column\_name | data\_type | nullable |
| :---------- | :----------- | :--------- | :------- |
| players     | agecategory  | TEXT       | 0        |
| players     | email        | INTEGER    | 0        |
| players     | nickname     | TEXT       | 0        |