Execute the SHOW TABLES statement to list the table names - Tablestore

You can execute the SHOW TABLES statement to list the names of tables in the current database.

Syntax

SHOW TABLES;

The following example provides a list of mapping table names in the current database.

SHOW TABLES;

List the names of mapping tables in the current database.

Tables_in_tpch

exampletable1
exampletable2

After you query the names of the mapping tables, perform operations based on your business requirements.

To use a mapping table to query data that meets specific conditions, execute the SELECT statement. For more information, see Query data.
To query details of a specific mapping table such as field names and field types, execute the DESCRIBE statement. For more information, see Query information about tables.
To update the attribute column of the mapping table after the attribute column of the data table is changed, execute the ALTER TABLE statement. For more information, see Update attribute columns of mapping tables.
To delete a mapping table, execute the DROP MAPPING TABLE statement. For more information, see Delete mapping tables.