Purpose
The oceanbase.DBA_OB_SEQUENCE_OBJECTS view displays all sequences in the database.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SEQUENCE_ID | bigint(20) | NO | The unique ID of a sequence in the current tenant. |
| SCHEMA_VERSION | bigint(20) | NO | The version of the schema that corresponds to the sequence record. |
| DATABASE_ID | bigint(20) | NO | The ID of the database to which the sequence belongs. |
| SEQUENCE_NAME | varchar(128) | NO | The name of the sequence. |
| MIN_VALUE | decimal(28,0) | NO | The minimum value of the sequence. |
| MAX_VALUE | decimal(28,0) | NO | The maximum value of the sequence. |
| INCREMENT_BY | decimal(28,0) | NO | The step size by which the sequence increments, which can be a positive or negative integer but cannot be 0. |
| START_WITH | decimal(28,0) | NO | The start value of the sequence. |
| CACHE_SIZE | decimal(28,0) | NO | The number of sequence values stored in the cache. |
| ORDER_FLAG | tinyint(4) | NO | Indicates whether sequence values are generated in order. |
| CYCLE_FLAG | tinyint(4) | NO | Indicates whether the sequence wraps when it reaches the minimum or maximum value. |
| IS_SYSTEM_GENERATED | tinyint(4) | NO | Indicates whether the sequence is internally generated. The value is set to True for sequences generated by IDENTITY COLUMN. |