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.
DROP MAPPING TABLE [IF EXISTS] table_name,...;
|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.|
Delete the mapping table of a table named exampletable.
DROP MAPPING TABLE IF EXISTS exampletable;