> ## 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](/docs/stable/sql-statements.md) lists all sequences in a database.

## Required privileges

No [privileges](/docs/stable/security-reference/authorization.md#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](/docs/stable/sql-name-resolution.md#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`](/docs/stable/create-sequence)
* [`DROP SEQUENCE`](/docs/stable/drop-sequence)
* [`ALTER SEQUENCE`](/docs/stable/alter-sequence)