Note
This view is available starting with V4.0.0.
Overview
Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| DATABASE_NAME | varchar(128) | NO | Database Name |
| TABLE_NAME | varchar(256) | NO | Table name |
| TABLE_ID | bigint(20) | NO | Table ID |
| TABLE_TYPE | varchar(13) | NO | Table type:
|
| PARTITION_NAME | varchar(64) | NO | The name of the partition. For a non-partitioned table, this parameter is NULL by default. |
| SUBPARTITION_NAME | varchar(64) | NO | Subpartition name. NULL if no subpartitions exist. |
| INDEX_NAME | varchar(256) | NO | Displays the index table name if it is an index table; otherwise, displays NULL. |
| DATA_TABLE_ID | bigint(20) | NO | Displays the ID of the primary table to which an index or LOB auxiliary table belongs. If no primary table is associated, NULL is displayed. |
| TABLET_ID | bigint(20) | NO | TABLET ID |
| LS_ID | bigint(20) | NO | Log stream where the object is located |
| ZONE | varchar(128) | NO | ZONE of the Replica |
| SVR_IP | varchar(46) | NO | IP address of the replica location |
| SVR_PORT | bigint(20) | NO | Port information of the replica location |
| ROLE | varchar(8) | NO | Replica Role |
| REPLICA_TYPE | varchar(18) | NO | Log stream replica type:
|
| DUPLICATE_SCOPE | varchar(7) | NO | Indicates whether this table is a replicated table. Valid values:
NoteThis field is available starting with V4.2.0. |
| DUPLICATE_READ_CONSISTENCY | varchar(6) | NO | Displays the read-consistency constraints for standby replicas of replicated tables. Valid values:
NoteThis field is available starting with V4.3.4. |
| OBJECT_ID | bigint(20) | NO | Object ID Corresponding to Partition
NoteThis field is available starting with V4.2.0. |
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group to which the table belongs.
NoteThis field is available starting with V4.2.0. |
| TABLEGROUP_ID | bigint(20) | NO | Table corresponding to the table group ID
NoteThis field is available starting with V4.2.0. |
| SHARDING | varchar(20) | NO | Sharding attribute (balanced mode) of the table corresponding to the table group.
NoteThis field is available starting with V4.2.0. |
| SCOPE | varchar(20) | NO | Table group'sSCOPEAttribute. Valid values:
NoteFor V4.4.2, this field is available starting with V4.4.2 BP1. |
| INDEX_TYPE | varchar(6) | NO | Displays the GLOBAL or LOCAL attribute of the index. Valid values:
Note
|