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 .NET V5.0.0 and later. When you use the SQL query feature, make sure that a supported version of Tablestore SDK for .NET is installed.

For more information, see Version history of Tablestore SDK for .NET.

Prerequisites

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

Method description

public SQLQueryResponse SQLQuery(SQLQueryRequest request)

Parameter description

request (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:

public static void DropMappingTable(OTSClient otsClient)
{
    SQLQueryRequest request = new SQLQueryRequest("drop mapping table test_table");
    SQLQueryResponse sqlQueryResponse = otsClient.SQLQuery(request);
}