Sequences

Learn about sequences in MariaDB Server. This section details how to create and manage sequences for generating unique numbers, often used for primary keys and other auto-incrementing values.

Sequence Overview

An overview of sequence objects, which generate a sequence of numeric values as defined by CREATE SEQUENCE.

CREATE SEQUENCE

Create a sequence generator. This statement initializes a sequence object that produces a series of unique numeric values on demand.

SHOW CREATE SEQUENCE

View the SQL used to create a sequence. This statement displays the CREATE SEQUENCE statement with current parameter values.

ALTER SEQUENCE

ALTER SEQUENCE changes the properties of an existing sequence object.

DROP SEQUENCE

DROP SEQUENCE removes one or more sequence objects.

SEQUENCE Functions

Learn about sequence functions in MariaDB Server. This section details SQL functions for retrieving the next or current value from a sequence, crucial for generating unique identifiers.

Information Schema SEQUENCES Table

The Information Schema SEQUENCES table provides metadata about sequence objects, including their minimum, maximum, and current values.

SHOW TABLES

Complete guide to listing tables in MariaDB. Complete SHOW TABLES syntax reference with LIKE patterns, WHERE conditions, and filtering options.

Error 4084: Sequence has run out

Error 4084: raised when a sequence without CYCLE reaches its MAXVALUE and can generate no more values.