> ## 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/show-columns",
  "feedback": "Description of the issue"
}
```

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

</AgentInstructions>

> Reference and syntax for the SHOW COLUMNS command.

# SHOW COLUMNS

Lists columns and their properties for a specified table. Returns `<table_name>`, `<column_name>`, `<data_type>`,
and `nullable` (`TRUE` if nullable, `FALSE` if not) for each column.

For more information regarding columns, see [information\_schema.columns](/reference-sql/information-schema/columns).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW COLUMNS [<table>];
```

## Parameters

| Parameter            | Description                                                  |
| :------------------- | :----------------------------------------------------------- |
| `<table>` (optional) | The name of the table for which the columns should be shown. |

## Returns

The returned table has the following columns.

| Column name  | Data Type | Description                               |
| :----------- | :-------- | :---------------------------------------- |
| table\_name  | TEXT      | Name of the table containing the column.  |
| column\_name | TEXT      | Name of the column.                       |
| data\_type   | TEXT      | The data type of the column.              |
| nullable     | BOOLEAN   | Indicates if the column may contain NULL. |

## Example

The following example highlights all of the columns from the `tournaments` table:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW COLUMNS tournaments;
```

| table\_name | column\_name            | data\_type | nullable |
| :---------- | :---------------------- | :--------- | :------- |
| tournaments | enddatetime             | TIMESTAMP  | FALSE    |
| tournaments | gameid                  | INTEGER    | FALSE    |
| tournaments | name                    | TEXT       | FALSE    |
| tournaments | rulesdefinition         | TEXT       | FALSE    |
| tournaments | SOURCE\_FILE\_NAME      | TEXT       | FALSE    |
| tournaments | SOURCE\_FILE\_TIMESTAMP | TIMESTAMP  | FALSE    |
| tournaments | startdatetime           | TIMESTAMP  | FALSE    |
| tournaments | totalprizedollars       | INTEGER    | FALSE    |
| tournaments | tournamentid            | INTEGER    | FALSE    |