SHOW SEQUENCES - CockroachDB

The SHOW SEQUENCES lists all sequences in a database.

Required privileges

No are required to list the sequences in a database.

Parameter	Description
`name`	The name of the database for which to list sequences. When omitted, the sequences in the are listed.

> CREATE SEQUENCE sequence_test;

> SHOW SEQUENCES;

  sequence_schema | sequence_name
------------------+----------------
  public          | sequence_test
(1 row)