SEQUENCES

Definition

The system table SEQUENCES contains all the sequences for which the current user has privileges.

Structure

SEQUENCES

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)

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

ORDER_FLAG

CHAR(1)

Specification, 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(10)

Creation date of the sequence

CREATETIME

TIME(8)

Creation time of the sequence

COMMENT

LONG

Comment on the sequence

See also:

Evaluating System Tables, SEQUENCES

SQL Reference Manual, Sequence Name (sequence_name)