This topic describes the conversion scope and incompatibilities of DDL synchronization during data migration from a MySQL database to the MySQL compatible mode 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 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
CREATE TABLE AS SELECT (CTAS)
Operations other than those listed in the "Supported operations" section of this topic are not supported.
Incompatibilities
For more information, see DDL incompatibilities between a MySQL database and an OceanBase Database MySQL compatible mode.