Purpose
The oceanbase.CDB_SUBPART_KEY_COLUMNS view provides the subpartitioning information of partitioned objects (tables and indexes) of all tenants.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| OWNER | varchar(128) | NO | The owner of the partitioned table or index. |
| NAME | varchar(128) | NO | The name of the partitioned table or index. |
| OBJECT_TYPE | varchar(5) | NO | The type of the partitioned object. Valid values: |
| COLUMN_NAME | text | NO | The name of the column. |
| COLUMN_POSITION | BIGINT(21) | NO | The position of the column in the partitioning key. |
| COLLATED_COLUMN_ID | bigint(0) | NO | At present, this column is not supported and is NULL by default. |