# Information Schema SEQUENCES Table

{% hint style="info" %}
This table is available as of MariaDB [11.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.5/what-is-mariadb-115).
{% endhint %}

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

It contains the following columns. See [CREATE SEQUENCE](https://mariadb.com/docs/server/reference/sql-structure/sequences/create-sequence) 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](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-overview)
* [CREATE SEQUENCE](https://mariadb.com/docs/server/reference/sql-structure/sequences/create-sequence)
* [ALTER SEQUENCE](https://mariadb.com/docs/server/reference/sql-structure/sequences/alter-sequence)
* [DROP SEQUENCE](https://mariadb.com/docs/server/reference/sql-structure/sequences/drop-sequence)
* [NEXT VALUE FOR](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/next-value-for-sequence_name)
* [PREVIOUS VALUE FOR](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/previous-value-for-sequence_name)
* [SETVAL()](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/setval). Set next value for the sequence.
* [AUTO INCREMENT](https://mariadb.com/docs/server/reference/data-types/auto_increment)
* [Sequence Storage Engine](https://mariadb.com/docs/server/server-usage/storage-engines/sequence-storage-engine)

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

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