DB_SEQUENCES
DB_SEQUENCES displays all sequences accessible to the current user. This view exists in both PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| sequence_owner | name | Owner of a sequence. |
| sequence_name | name | Name of the sequence. |
| min_value | int16 | Minimum value of the sequence. |
| max_value | int16 | Maximum value of the sequence. |
| last_number | int16 | Value of the previous sequence. |
| cache_size | int16 | Size of the sequence disk cache. |
| increment_by | int16 | Value by which the sequence is incremented. |
| cycle_flag | character(1) | Specifies whether the sequence is a cyclic sequence. The value can be Y or N.
|
| order_flag | character varying(1) | Specifies whether a sequence occurs in a request sequence. Not supported. Its value is NULL. |
| scale_flag | character varying(1) | Specifies whether a sequence is a scalable sequence. Not supported. Its value is NULL. |
| extend_flag | character varying(1) | Specifies whether the value generated by a scalable sequence exceeds the maximum or minimum value of the sequence. Not supported. Its value is NULL. |
| sharded_flag | character varying(1) | Specifies whether a sequence is a shard sequence. Not supported. Its value is NULL. |
| session_flag | character varying(1) | Specifies whether a sequence is a private session. Not supported. Its value is NULL. |
| keep_value | character varying(1) | Specifies whether to retain the sequence value during replay after a failure. Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
