If the attribute column of a table is modified, you can execute the DROP MAPPING TABLE statement to delete the mapping table of the table and recreate a mapping table for the table. You can delete the mapping tables of multiple tables in a single request.
Note The DROP MAPPING TABLE statement does not delete the tables in Tablestore.
Syntax
DROP MAPPING TABLE [IF EXISTS] table_name,...;
Parameters
Parameter | Required | Description |
---|---|---|
table_name | Yes | The name of the table. You can configure multiple table names that are separated with commas (,) in a single request. |
IF EXISTS | No | Specifies whether a success response is returned. If you specify IF EXISTS, a success response is returned regardless of whether the mapping table exists. Otherwise, a success response is returned only when the mapping table exists. |
Example
Delete the mapping table of a table named exampletable.
DROP MAPPING TABLE IF EXISTS exampletable;