USER_SEQUENCES v11
The USER_SEQUENCES view provides information about all user-defined sequences that belong to the current user.
| Name | Type | Description |
|---|---|---|
schema_name | TEXT | The name of the schema in which the sequence resides. |
sequence_name | TEXT | Name of the sequence. |
min_value | NUMERIC | The lowest value that the server will assign to the sequence. |
max_value | NUMERIC | The highest value that the server will assign 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 if the sequence should wrap when it reaches min_value or max_value. |
order_flag | CHARACTER VARYING | Included for compatibility only; always 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 disk. |