Feature
This view provides information about all auto-increment columns in the current tenant.
Fields
| Field | 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. |
| AUTO_INCREMENT_KEY | bigint(20) | NO | The KEY of the table where the auto-increment column is located. |
| COLUMN_ID | bigint(20) | NO | The ID of the column. |
| AUTO_INCREMENT_VALUE | bigint(20) unsigned | YES | The next auto-increment value that is available. |
| SYNC_VALUE | bigint(20) unsigned | NO | The synchronization value, that is, the value of the auto-increment column that is specified by the INSERT statement. The value is greater than the current value of the auto-increment column. |