sequences

The view information_schema.sequences contains all sequences defined in the database.

SELECT * FROM information_schema.sequences;
SELECT sequence_schema, sequence_name, current_value FROM information_schema.sequences;

information_schema.sequences

column nametyperemarks
sequence_catalogVARCHARAlways NULL
sequence_schemaVARCHAR
sequence_nameVARCHAR
data_typeVARCHARCurrently always BIGINT
numeric_precisionSMALLINT
numeric_precision_radixSMALLINT
numeric_scaleSMALLINT
start_valueBIGINT
minimum_valueBIGINT
maximum_valueBIGINT
incrementBIGINT
cycle_optionVARCHARNO or YES
declared_data_typeVARCHARAlways NULL
declared_numeric_precisionSMALLINTAlways NULL
declared_numeric_scaleSMALLINTAlways NULL
schema_idINTEGERreference to sys.schemas.id
sequence_idINTEGERreference to sys.sequences.id
current_valueBIGINT
cacheincBIGINTcache increment value
commentsVARCHAR

Note: The last 5 columns (schema_id, sequence_id, current_value, cacheinc and comments) are extensions to the view as defined by ISO standard. They provide useful information and simplify filtering and joins with system tables/views in sys schema when needed.