Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
INFORMATION_SCHEMA.META_CLUSTER_DATA_OBJECTS displays metadata related to data objects within the instance.Field Name | Type | Description |
data_obj_id | int unsigned | ID of the data object. |
data_obj_name | varchar(64) | Naming of data objects. |
data_obj_type | varchar(64) | Type of data object. |
data_space_type | varchar(64) | Type of data space. |
distribution_policy_id | int unsigned | Bound DP ID. |
schema_name | varchar(64) | Naming of data objects. |
table_name | varchar(64) | Table name. |
partition_name | varchar(64) | Primary partition name (NULL if not a primary partition). |
sub_partition_name | varchar(64) | Second-level partition name (NULL if not a second-level partition). |
index_name | varchar(64) | Index name ( PRIMARY if it is a primary key index). |
tdsql>select * from INFORMATION_SCHEMA.META_CLUSTER_DATA_OBJECTS Limit 1\\G*************************** 1. row ***************************data_obj_id: 268data_obj_name: time_zonedata_obj_type: BASE_TABLEdata_space_type: DATA_SPACE_TYPE_SYSTEMdistribution_policy_id: 1schema_name: mysqltable_name: time_zonepartition_name:sub_partition_name:index_name: PRIMARY1 row in set (0.01 sec)
피드백