USER_SEQUENCES v16

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

NameTypeDescription
schema_nameTEXTName of the schema in which the sequence resides.
sequence_nameTEXTName of the sequence.
min_valueNUMERICLowest value for the server to assign to the sequence.
max_valueNUMERICHighest value for the server to assign to the sequence.
increment_byNUMERICValue added to the current sequence number to create the next sequent number.
cycle_flagCHARACTER VARYINGSpecifies whether the sequence wraps when it reaches min_value or max_value.
order_flagCHARACTER VARYINGIncluded only for compatibility. Always Y.
cache_sizeNUMERICNumber of preallocated sequence numbers in memory.
last_numberNUMERICThe value of the last sequence number saved to disk.