On this page 
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.
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
> CREATE SEQUENCE sequence_test;
> SHOW SEQUENCES;
sequence_schema | sequence_name
------------------+----------------
public | sequence_test
(1 row)
See also
Was this helpful?
