select
-- (part of) the database file name, most likely not useful
-- for example "TEST" for the jdbc URL "jdbc:h2:~/test"
SEQUENCE_CATALOG,
-- the schema name of the sequence, by default "PUBLIC"
SEQUENCE_SCHEMA,
-- the name of the sequence
SEQUENCE_NAME,
-- the increment (1 by default)
INCREMENT
from information_schema.sequences
Example (generated by the H2 Console tool):
create sequence test_seq;
@list select * from information_schema.sequences
Column Data
Row # 1
SEQUENCE_CATALOG TEST4
SEQUENCE_SCHEMA PUBLIC
SEQUENCE_NAME TEST_SEQ
CURRENT_VALUE 0
INCREMENT 1
IS_GENERATED FALSE
REMARKS
CACHE 32
MIN_VALUE 1
MAX_VALUE 9223372036854775807
IS_CYCLE FALSE
ID 11
IS_GENERATED is for auto-generated sequences, for example if you use "create table test(id int auto_increment)"