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
SQL query is supported in Tablestore SDK for .NET V5.0.0 and later. Make sure that a supported SDK version 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)
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);
}