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

# SHOW COLUMNS

## Synopsis

```text theme={null}
SHOW COLUMNS FROM table [ LIKE pattern ]
```

## Description

List the columns in a `table` along with their data type and other attributes:

```sql theme={null}
SHOW COLUMNS FROM nation;
```

```sql theme={null}
  Column   |     Type     | Extra | Comment
-----------+--------------+-------+---------
 nationkey | bigint       |       |
 name      | varchar(25)  |       |
 regionkey | bigint       |       |
 comment   | varchar(152) |       |
```

[Specify a pattern](/sql/functions/comparison#pattern-comparison-like) in the optional `LIKE` clause to
filter the results to the desired subset. For example, the following query
allows you to find columns ending in `key`:

```sql theme={null}
SHOW COLUMNS FROM nation LIKE '%key';
```

```sql theme={null}
  Column   |     Type     | Extra | Comment
-----------+--------------+-------+---------
 nationkey | bigint       |       |
 regionkey | bigint       |       |
```