Incompatibilities of DROP INDEX operations

2025-07-22 02:38:36  Updated

This topic describes DROP INDEX DDL operations that are executed in a MySQL database and can be converted by the DDL synchronization component of OceanBase Migration Service (OMS), but they cannot be executed in the MySQL-compatible tenant of OceanBase Database when you migrate data from the MySQL database to the MySQL-compatible tenant of OceanBase Database.

Delete an index referenced by a foreign key

An INDEX with foreign key dependency indicates that the columns in the INDEX involve foreign key dependency or reference.

  • MySQL databases: not supported.

  • MySQL-compatible tenants of OceanBase Database: supported.

Contact Us