Tablestore:List the names of mapping tables

Prerequisites

• An OTSClient instance is initialized. For more information, see Initialize an OTSClient instance.

• A mapping table is created. For more information, see Create mapping tables.

Usage notes

Tablestore SDK for PHP V5.1.0 or later supports the SQL query feature. Before you use the SQL query feature, make sure that Tablestore SDK for PHP V5.1.0 or later is obtained. For information about the versions of Tablestore SDK for PHP, see Version history of Tablestore SDK for PHP.

Examples

The following sample code provides an example on how to execute the SHOW TABLES statement to list the names of mapping tables that are created for tables in an instance.

$request = array(
    'query' => "SHOW TABLES;",
);
$response = $otsClient->sqlQuery ($request);
$sqlRows = $response['sql_rows'];
print json_encode($sqlRows, JSON_PRETTY_PRINT);

References

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 mapping table such as field names and field types, execute the DESCRIBE statement. For more information, see Query information about a table.

• To update the attribute column of a mapping table after an 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.