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. |