This topic describes the supported conversion scope of DROP TABLE DDL operations during data migration from a MySQL database to a MySQL tenant of OceanBase Database.
Syntax
Use DROP TABLE to drop one or more tables.
DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]Ignored clauses and options
Important
The following clauses and options will be ignored and will not be resolved or converted when they are specified in the synchronized DDL statements.
TEMPORARY in MySQL tenants of OceanBase Database of a version earlier than V3.2.3
IF EXISTS
RESTRICT | CASCADE