USER_SEQUENCES v11

The USER_SEQUENCES view provides information about all user-defined sequences that belong to the current user.

NameTypeDescription
schema_nameTEXTThe name of the schema in which the sequence resides.
sequence_nameTEXTName of the sequence.
min_valueNUMERICThe lowest value that the server will assign to the sequence.
max_valueNUMERICThe highest value that the server will assign to the sequence.
increment_byNUMERICThe value added to the current sequence number to create the next sequent number.
cycle_flagCHARACTER VARYINGSpecifies if the sequence should wrap when it reaches min_value or max_value.
order_flagCHARACTER VARYINGIncluded for compatibility only; always Y.
cache_sizeNUMERICThe number of pre-allocated sequence numbers in memory.
last_numberNUMERICThe value of the last sequence number saved to disk.