Purpose
The oceanbase.CDB_OB_AUTO_INCREMENT view displays information about all auto-increment columns in the cluster. You can query this view only from the sys tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| CREATE_TIME | datetime(6) | YES | The time when the auto-increment column was created. |
| MODIFY_TIME | datetime(6) | YES | The time when the auto-increment column was modified. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| AUTO_INCREMENT_KEY | bigint(20) | NO | The key of the table where the auto-increment column belongs. |
| COLUMN_ID | bigint(20) | NO | The ID of the column. |
| AUTO_INCREMENT_VALUE | bigint(20) unsigned | YES | The next available value of the auto-increment column. |
| SYNC_VALUE | bigint(20) unsigned | NO | The sync value. It is explicitly specified for the auto-increment column by using the INSERT statement and is greater than the current value of this column. |