SHOW SEQUENCES

Warning:
Cockroach Labs will stop providing Assistance Support for this version on May 10, 2022. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see 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

SHOW SEQUENCES FROM name

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

icon/buttons/copy
> CREATE SEQUENCE sequence_test;
icon/buttons/copy
> SHOW SEQUENCES;
  sequence_schema | sequence_name
------------------+----------------
  public          | sequence_test
(1 row)

See also

YesYes NoNo