The ALL_SEQUENCES view provides the information about all user-defined sequences on which the user has SELECT or UPDATE permissions.

Parameter Type Description
sequence_owner TEXT The username of the sequence owner.
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 minimun value that the server assigns to the sequence.
max_value NUMERIC The maximun 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 Indicates whether the sequence wraps if it reaches min_value or max_value.
order_flag CHARACTER VARYING This parameter always returns the value of Y.
cache_size NUMERIC The number of preallocated sequence numbers stored in memory.
last_number NUMERIC The value of the last sequence number saved to the disk.