The Information Schema SEQUENCES table provides metadata about sequence objects, including their minimum, maximum, and current values.
The Information Schema SEQUENCES table stores information about sequences on the server.
It contains the following columns. See CREATE SEQUENCE for details.
This page is licensed: CC BY-SA / Gnu FDL
SETVAL(). Set next value for the sequence.
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
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