> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-structure/sequences.md).

# Sequences

{% columns %}
{% column %}
{% content-ref url="/pages/A4y7aaupMEUcvWRGGGZG" %}
[Sequence Overview](/docs/server/reference/sql-structure/sequences/sequence-overview.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An overview of sequence objects, which generate a sequence of numeric values as defined by CREATE SEQUENCE.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/7Gk8FHG3shKnN1pFCVfS" %}
[CREATE SEQUENCE](/docs/server/reference/sql-structure/sequences/create-sequence.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Create a sequence generator. This statement initializes a sequence object that produces a series of unique numeric values on demand.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/LEzhrCb38GuGysDqXBsw" %}
[SHOW CREATE SEQUENCE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
View the SQL used to create a sequence. This statement displays the CREATE SEQUENCE statement with current parameter values.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SV3w5hjmK2gz5IGw0Aa0" %}
[ALTER SEQUENCE](/docs/server/reference/sql-structure/sequences/alter-sequence.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
ALTER SEQUENCE changes the properties of an existing sequence object.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/pJXauHixmHrhyjJZIjVD" %}
[DROP SEQUENCE](/docs/server/reference/sql-structure/sequences/drop-sequence.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
DROP SEQUENCE removes one or more sequence objects.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/sGlywLBXWWAjCRnzWNmf" %}
[SEQUENCE Functions](/docs/server/reference/sql-structure/sequences/sequence-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/8qZKhA6PyUtG1SLBkGvg" %}
[Information Schema SEQUENCES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-sequences-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Information Schema SEQUENCES table provides metadata about sequence objects, including their minimum, maximum, and current values.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fhWQQ2nu9nmXas76QmFn" %}
[SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to listing tables in MariaDB. Complete SHOW TABLES syntax reference with LIKE patterns, WHERE conditions, and filtering options.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SUWg8D62OvxETDaTr0Vd" %}
[Error 4084: Sequence has run out](/docs/server/reference/error-codes/mariadb-error-codes-4000-to-4099/e4084.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Error 4084: raised when a sequence without CYCLE reaches its MAXVALUE and can generate no more values.
{% endcolumn %}
{% endcolumns %}