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
The following code provides an example on how to execute the DROP MAPPING TABLE `tableName`; statement to delete the mapping table that is created for the table named tableName:
$request = array(
'query' => 'DROP MAPPING TABLE `tableName`;'
);
$response = $this->otsClient->sqlQuery($request);
print json_encode($sqlRows, JSON_PRETTY_PRINT);