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

# SHOW COLUMNS

> Use the `SHOW COLUMNS` command to view columns in the specified table, source, sink, view or materialized view.

<Tip>
  [`DESCRIBE <relation_name>`](/sql/commands/sql-describe) provides similar functionality, but with more detailed information.
</Tip>

## Syntax

```sql theme={null}
SHOW COLUMNS FROM relation_name [ LIKE_expression ];
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                  |
| :------------------ | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *relation\_name*    | The name of the table, source, sink, view, or materialized view from which the columns will be listed.                                                                       |
| LIKE\_expression    | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions). |

## Examples

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