All Products
Search
Document Center

Tablestore:Delete a mapping table

Last Updated:Apr 28, 2025

You can use the DROP MAPPING TABLE statement to delete a mapping table. You can delete multiple mapping tables at the same time.

Usage notes

The SQL query feature is supported by Tablestore SDK for Node.js V5.2.0 and later. When you use the SQL query feature, make sure that a supported version of Tablestore SDK for Node.js is installed.

For information about the version history of Tablestore SDK for Node.js, see Version history of Tablestore SDK for Node.js.

Prerequisites

A client is initialized. For more information, see Initialize a Tablestore client.

Method

sqlQuery: function sqlQuery(params, callback)

Parameters

params (required): the SQL statement to execute.

Sample code

The following sample code provides an example on how to execute the DROP MAPPING TABLE statement to delete a mapping table named test_table:

const params = {
  query: "drop mapping table test_table",
}

client.sqlQuery(params, function (err, data) {
  if (err) {
    console.log('sqlQuery error:', err.toString());
  } else {
    console.log('sqlQuery success:', data);
  }
});