All Products
Search
Document Center

ApsaraDB for OceanBase:Incompatibilities of DROP INDEX operations

Last Updated:Jun 03, 2024

This topic describes the scenarios where DROP INDEX DDL operations performed in a MySQL database can be converted by the DDL synchronization component of the data transmission service but cannot be performed in a MySQL tenant of OceanBase Database during data migration from the MySQL database to the MySQL 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 tenants of OceanBase Database: supported.