> ## 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 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":"css-variables","dark":"css-variables"}}
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":"css-variables","dark":"css-variables"}}
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 |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.