ALL_SEQUENCES v17
The ALL_SEQUENCES
view provides information about all user-defined sequences on which the user has SELECT
or UPDATE
privileges.
Name | Type | Description |
---|---|---|
sequence_owner | TEXT | User name of the sequence owner. |
schema_name | TEXT | Name of the schema in which the sequence resides. |
sequence_name | TEXT | Name of the sequence. |
min_value | NUMERIC | Lowest value that the server assigns to the sequence. |
max_value | NUMERIC | Highest value that the server assigns to the sequence. |
increment_by | NUMERIC | Value added to the current sequence number to create the next sequent number. |
cycle_flag | CHARACTER VARYING | Specifies whether the sequence wraps when it reaches min_value or max_value . |
order_flag | CHARACTER VARYING | Always returns Y . |
cache_size | NUMERIC | Number of preallocated sequence numbers stored in memory. |
last_number | NUMERIC | Value of the last sequence number saved to disk. |