> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# SHOW SEQUENCES
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `SHOW SEQUENCES` statement lists all sequences in a database.
## Required privileges
No privileges are required to list the sequences in a database.
## Synopsis
## Parameters
| Parameter | Description |
| --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `name` | The name of the database for which to list sequences. When omitted, the sequences in the 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`
* `DROP SEQUENCE`
* `ALTER SEQUENCE`