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

> Use the `SHOW INDEXES` command to view indexes from a particular table.

## Syntax

```sql theme={null}
SHOW INDEXES FROM table_name [ LIKE_expression ];
```

## Parameters

| Parameter        | Description                                                                                                                                                                  |
| :--------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *table\_name*    | The table from which indexes will be displayed.                                                                                                                              |
| 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). |

## Example[](#example "Direct link to Example")

We can create a table `t3` and an index `idx1` on `t3`.

```sql theme={null}
CREATE TABLE IF NOT EXISTS t3 (
    v1 int,
    v2 int,
    v3 int);

CREATE INDEX idx1 ON t3 (v1,v2);
```

Next, we can use the `SHOW INDEXES` command on `t3` to see existing indexes.

```sql theme={null}
SHOW INDEXES FROM t3;
```

```sql theme={null}
 Name | On |      Key       | Include | Distributed By
------+----+----------------+---------+----------------
 idx1 | t3 | v1 ASC, v2 ASC | v3      | v1, v2
(1 row)
```

## Related topics

<CardGroup>
  <Card title="CREATE INDEX" icon="database" iconType="solid" href="/sql/commands/sql-create-index" />
</CardGroup>