On this page
Warning:CockroachDB v19.2 is no longer supported. 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)