This topic introduces both the supported and unsupported DDL statements in the migration from Aurora MySQL DB clusters to the MySQL-compatible tenants of OceanBase Database.
Supported DDL statements
ALTER TABLE
TRUNCATE TABLE
RENAME TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
Unsupported DDL statements
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
Except for the supported DDL statements listed above, all the other DDL statements are not supported at the moment.