Warning:Cockroach Labs will stop providing Assistance Support for this version on May 12, 2021. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see the Release Support Policy.
SHOW SEQUENCES statement lists all sequences in a database.
No privileges are required to list the sequences in a database.
||The name of the database for which to list sequences. When omitted, the sequences in the current database are listed.|
> CREATE SEQUENCE sequence_test;
> SHOW SEQUENCES;
sequence_name --------------- sequence_test (1 row)