The content of this page has been automatically translated by AI. If you encounter any problems while reading, you can view the corresponding content in Chinese.

show

Last updated: 2024-10-15 17:37:38

Introduction

Query server-side, table basic information. 'show tables' queries table type, protocol type. 'show status' queries current connection status, directory server information, and access layer information.

Syntax

show [status/tables];

Parameters

Parameter Name
Description
table
Table Name

Example

Query table information under the current table group:
tcaplus> show tables;

----------------------------------------------------------
| Table Name Type Protocol |
----------------------------------------------------------
| test_table GENERIC TDR |
| tbMailTest LIST PROTOBUF |
| pb_generic_index_shardingkey GENERIC PROTOBUF |
| pb_generic_index_noshardkey GENERIC PROTOBUF |
| pb_generic_noindex_noshardkey GENERIC PROTOBUF |
| pb_list LIST PROTOBUF |
| pb_list2 LIST PROTOBUF |
| pb_sortedlist LIST PROTOBUF |
| aes_info GENERIC TDR |
| auth_info GENERIC TDR |
| depend_me_services GENERIC TDR |
| host_info GENERIC TDR |
| instance_info GENERIC TDR |
| node_info GENERIC TDR |
| service_depends GENERIC TDR |
| service_info GENERIC TDR |
| token_info GENERIC TDR |
| cl_list LIST PROTOBUF |
| cl_generic GENERIC PROTOBUF |
| table_generic GENERIC TDR |
----------------------------------------------------------