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

# SHOW SEQUENCES

The `SHOW SEQUENCES` [statement](https://docs.cockroachlabs.com/docs/v24.2/sql-statements) lists all sequences in a database.

## Required privileges

No [privileges](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#managing-privileges) are required to list the sequences in a database.

## Synopsis

![show\_sequences syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/show_sequences.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=003d747f980eb96ae8f010ac39e24f42)

## Parameters

| Parameter | Description |
| - | - |
| `name` | The name of the database for which to list sequences. When omitted, the sequences in the [current database](https://docs.cockroachlabs.com/docs/v24.2/sql-name-resolution#current-database) are listed. |

## Example

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> CREATE SEQUENCE sequence_test;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW SEQUENCES;
```

```
  sequence_schema | sequence_name
------------------+----------------
  public          | sequence_test
(1 row)
```

## See also

* [`CREATE SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/create-sequence)
* [`DROP SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/drop-sequence)
* [`ALTER SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/alter-sequence)