> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/metadata/describe",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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":"github-light","dark":"github-dark"}}
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":"github-light","dark":"github-dark"}}
DESCRIBE prices
```

**Returns:**

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