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

Parameter Type Description
schema_name TEXT The name of the schema to which the sequence belongs.
sequence_name TEXT The name of the sequence.
min_value NUMERIC The lowest value that the server assigns to the sequence.
max_value NUMERIC The highest value that the server assigns to the sequence.
increment_by NUMERIC The value added to the current sequence number to create the next sequent number.
cycle_flag CHARACTER VARYING Specifies whether the sequence wraps if it reaches min_value or max_value.
order_flag CHARACTER VARYING This parameter is supported for compatibility only. The value is Y.
cache_size NUMERIC The number of pre-allocated sequence numbers in memory.
last_number NUMERIC The value of the last sequence number saved to the disk.