Skip to main content

Sequence

This page provides a comprehensive overview of sequence operations in Databend, organized by functionality for easy reference.

Sequence Management

CommandDescription
CREATE SEQUENCECreates a new sequence generator
DROP SEQUENCERemoves a sequence generator

Sequence Information

CommandDescription
DESC SEQUENCEShows detailed information about a sequence
SHOW SEQUENCESLists all sequences in the current or specified database
note

Sequences in Databend are used to generate unique numeric values in a sequential order, commonly used for primary keys or other unique identifiers.

Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today