You can execute the DROP MAPPING TABLE statement to delete mapping tables that are created for 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. Specify the parameter based on the required feature. |
Example
Execute the drop mapping table test_table statement to delete the mapping table that is created for the table named test_table.
def drop_mapping_table(client):
query = 'drop mapping table test_table'
client.exe_sql_query(query)