Purpose
The oceanbase.DBA_SEQUENCES view displays all sequences under the current tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SEQUENCE_OWNER | varchar(128) | NO | The name of the database in which the sequence resides. |
| SEQUENCE_NAME | varchar(128) | NO | The name of the sequence. |
| MIN_VALUE | decimal(28,0) | NO | The minimum value supported. |
| MAX_VALUE | decimal(28,0) | NO | The maximum value supported. |
| INCREMENT_BY | decimal(28,0) | NO | The step size by which the sequence is incremented, which can be a positive or negative integer but cannot be 0. |
| CYCLE_FLAG | varchar(1) | NO | Indicates whether the sequence wraps when it reaches the minimum or maximum value. |
| ORDER_FLAG | varchar(1) | NO | Indicates whether sequence values are generated in order. |
| CACHE_SIZE | decimal(28,0) | NO | The number of sequence values stored in the cache. |
| LAST_NUMBER | decimal(38,0) | NO | The value of the last sequence number written to the disk. |