Information Schema SEQUENCES Table

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

This table is available as of MariaDB 11.5.

The Information Schema SEQUENCES table stores information about sequences on the server.

It contains the following columns. See 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

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

• CREATE SEQUENCE

• ALTER SEQUENCE

• DROP SEQUENCE

• NEXT VALUE FOR

• PREVIOUS VALUE FOR

• SETVAL(). Set next value for the sequence.

• AUTO INCREMENT

• Sequence Storage Engine

_{This page is licensed: CC BY-SA / Gnu FDL}