> 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/system-tables/information-schema/information-schema-tables/information-schema-sequences-table.md).

# Information Schema SEQUENCES Table

{% hint style="info" %}
This table is available as of MariaDB [11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md).
{% endhint %}

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `SEQUENCES` table stores information about [sequences](/docs/server/reference/sql-structure/sequences.md) on the server.

It contains the following columns. See [CREATE SEQUENCE](/docs/server/reference/sql-structure/sequences/create-sequence.md) for details.

| Column                    | Description                                       |
| ------------------------- | ------------------------------------------------- |
| SEQUENCE\_CATALOG         | Catalog name                                      |
| SEQUENCE\_SCHEMA          | Database name                                     |
| SEQUENCE\_NAME            | Sequence name                                     |
| DATA\_TYPE                | Data type, for example BIGINT or TINYINT UNSIGNED |
| NUMERIC\_PRECISION        |                                                   |
| NUMERIC\_PRECISION\_RADIX |                                                   |
| NUMERIC\_SCALE            |                                                   |
| START\_VALUE              |                                                   |
| MINIMUM\_VALUE            |                                                   |
| MAXIMUM\_VALUE            |                                                   |
| INCREMENT                 |                                                   |
| CYCLE\_OPTION             | 1 if the CYCLE OPTION is set, otherwise 0         |

## Example

```sql
CREATE SEQUENCE s START WITH 100 INCREMENT BY 10;

SELECT * FROM INFORMATION_SCHEMA.SEQUENCES\G
*************************** 1. row ***************************
       SEQUENCE_CATALOG: def
        SEQUENCE_SCHEMA: test
          SEQUENCE_NAME: s
              DATA_TYPE: bigint
      NUMERIC_PRECISION: 64
NUMERIC_PRECISION_RADIX: 2
          NUMERIC_SCALE: 0
            START_VALUE: 100
          MINIMUM_VALUE: 1
          MAXIMUM_VALUE: 9223372036854775806
              INCREMENT: 10
           CYCLE_OPTION: 0
```

## See Also

* [Sequence Overview](/docs/server/reference/sql-structure/sequences/sequence-overview.md)
* [CREATE SEQUENCE](/docs/server/reference/sql-structure/sequences/create-sequence.md)
* [ALTER SEQUENCE](/docs/server/reference/sql-structure/sequences/alter-sequence.md)
* [DROP SEQUENCE](/docs/server/reference/sql-structure/sequences/drop-sequence.md)
* [NEXT VALUE FOR](/docs/server/reference/sql-structure/sequences/sequence-functions/next-value-for-sequence_name.md)
* [PREVIOUS VALUE FOR](/docs/server/reference/sql-structure/sequences/sequence-functions/previous-value-for-sequence_name.md)
* [SETVAL()](/docs/server/reference/sql-structure/sequences/sequence-functions/setval.md). Set next value for the sequence.
* [AUTO INCREMENT](/docs/server/reference/data-types/auto_increment.md)
* [Sequence Storage Engine](/docs/server/server-usage/storage-engines/sequence-storage-engine.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}