You can execute the drop mapping table statement to delete mapping tables.
Note For more information about the drop mapping table statement, see Delete mapping tables.
Prerequisites
- An OTSClient instance is initialized. For more information, see Initialization.
- A mapping table is created. For more information, see Create mapping tables.
Parameters
| Parameter | Description |
|---|---|
| query | The SQL statement. Configure the parameter based on the required feature. |
Examples
Execute the drop mapping table test_table statement to delete the mapping table of the table named test_table.
/// <summary>
/// Delete a mapping table for a table.
/// </summary>
/// <param name="otsClient"></param>
public static void DropMappingTable(OTSClient otsClient)
{
SQLQueryRequest sqlQuery = new SQLQueryRequest("drop mapping table test_table");
SQLQueryResponse sqlQueryResponse = otsClient.SQLQuery(sqlQuery);
}