SCHEMANAME

CHAR(32)

Name of the schema of the sequence

OWNER

CHAR(32)

Name of the owner of the sequence

SEQUENCE_NAME

CHAR(32)

Name of the sequence

MIN_VALUE

FIXED(38)

Minimum value of the sequence

MAX_VALUE

FIXED(38)

Maximum value of the sequence

INCREMENT_BY

FIXED(38)

Value by which the sequence is increased

CYCLE_FLAG

CHAR(1)

Specifies whether the sequence starts again from the minimum value after the maximum value is reached (N | Y)

ORDER_FLAG

CHAR(1)

Specifies whether the sequence values are allocated in the order of the request (Y | N)

CACHE_SIZE

FIXED(38)

Number of sequence values that are loaded to the cache simultaneously

LAST_NUMBER

FIXED(38)

Last sequence value stored

CREATEDATE

DATE

Creation date of the sequence

CREATETIME

TIME

Creation time of the sequence

COMMENT

CLOB

Comment on the sequence