The ALL_SEQUENCES view lists all user-defined sequences on which you hold SELECT or UPDATE permission.
Columns
| Column | Type | Description |
|---|---|---|
sequence_owner | TEXT | The username of the sequence owner. |
schema_name | TEXT | The name of the schema that contains the sequence. |
sequence_name | TEXT | The name of the sequence. |
min_value | NUMERIC | The minimum value the server assigns to the sequence. |
max_value | NUMERIC | The maximum value the server assigns to the sequence. |
increment_by | NUMERIC | The value added to the current sequence number to produce the next sequence number. |
cycle_flag | CHARACTER VARYING | Whether the sequence wraps around when it reaches min_value or max_value. |
order_flag | CHARACTER VARYING | Always returns Y. |
cache_size | NUMERIC | The number of preallocated sequence numbers held in memory. |
last_number | NUMERIC | The last sequence number written to disk. |