Overview of DDL synchronization from a MySQL database to a MySQL tenant of OceanBase Database

Supported DDL operations

• CREATE TABLE: For more information, see CREATE TABLE.

• ALTER TABLE: For more information, see ALTER TABLE.

• TRUNCATE TABLE: For more information, see TRUNCATE TABLE.

• RENAME TABLE: For more information, see RENAME TABLE.

• DROP TABLE: For more information, see DROP TABLE.

• CREATE INDEX: For more information, see CREATE INDEX.

• DROP INDEX: For more information, see DROP INDEX.

Unsupported DDL operations

• CREATE/DROP/ALTER DATABASE

• CREATE/DROP/ALTER FUNCTION

• CREATE/DROP/ALTER PROCEDURE

• CREATE/DROP/ALTER EVENT

• CREATE/DROP/ALTER VIEW

• CREATE/DROP/ALTER ROLE

• CREATE/DROP/ALTER TRIGGER

• CREATE/DROP/ALTER USER

• CREATE/DROP/ALTER SERVER

• CREATE/DROP/ALTER TABLESPACE

• DDL operations other than those listed in the "Supported DDL operations" section of this topic are not supported.

Incompatibilities

For more information, see DDL incompatibilities between a MySQL database and a MySQL tenant of OceanBase Database.