DROP TABLE

2025-05-12 01:55:52  Updated

This topic describes the supported conversion scope of DROP TABLE DDL operations during data migration from a MySQL database to a MySQL-compatible 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

Warning

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-compatible tenants of OceanBase Database of a version earlier than V3.2.3

  • IF EXISTS

  • RESTRICT | CASCADE

Contact Us