This topic describes the support of data migration or synchronization tasks of different data source types for DDL statements related to tables and indexes.
Considerations
This topic does not cover all specific scenarios, such as all options of
ALTER TABLE ADD COLUMN, due to the complexity of DDL statements. For any unsupported scenarios, take actions as prompted or contact OceanBase Technical Support.The DDL statements listed in this topic are only for your reference. The actual syntax varies slightly based on the database. Therefore, you must determine the supported DDL statements for synchronization based on the statement syntax of your database.
The
CREATEDDL statements listed in this topic will be synchronized to the target database only if objects are selected by using the Match Rules option and the names of tables created by using theCREATEstatements match the migration object rules.The
RENAMEDDL statements listed in this topic will be synchronized to the target database only if objects are selected by using the Match Rules option and the names of tables created by using theRENAMEstatements match the migration object rules.The index-related DDL statements listed in this topic will be synchronized to the target only if the names of tables where the indexes belong match the migration object rules.
For the support status of DDL statements in reverse incremental migration in a data migration task, see the corresponding section in this topic based on the data source types in the order of "target->source". For example, for the support status DDL statements in reverse incremental migration in a data migration task whose source is a MySQL database and target is a MySQL-compatible tenant of OceanBase Database, see the OB_MySQL -> MySQL section of this topic.
MySQL -> OB_MySQL
The following table lists the supported DDL statements for synchronization when you migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database. For more information, see Synchronize DDL operations from a MySQL database to a MySQL-compatible tenant of OceanBase Database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | No |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | No |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the target is OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | Yes |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_MySQL -> MySQL
The following table lists the supported DDL statements for synchronization when you migrate data from a MySQL-compatible tenant of OceanBase Database to a MySQL database. For more information, see Synchronize DDL operations from a MySQL-compatible tenant of OceanBase Database to a MySQL database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | No |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | No |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source is OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | Yes |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_MySQL -> OB_MySQL
The following table lists the supported DDL statements for synchronization when you migrate data between MySQL-compatible tenants of OceanBase Database. For more information, see Synchronize DDL operations between MySQL-compatible tenants of OceanBase Database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | No |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | No |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source and target are MySQL-compatible tenants of OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | Yes |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
Oracle -> OB_Oracle
The following table lists the supported DDL statements for synchronization when you migrate data from an Oracle database to an Oracle-compatible tenant of OceanBase Database. For more information, see Synchronize DDL operations from an Oracle database to an Oracle-compatible tenant of OceanBase Database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | N/A |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | N/A |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | N/A |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the target is OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | N/A |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_Oracle -> Oracle
The following table lists the supported DDL statements for synchronization when you migrate data from an Oracle-compatible tenant of OceanBase Database to an Oracle database. For more information, see Synchronize DDL operations from an Oracle-compatible tenant of OceanBase Database to an Oracle database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | N/A |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | N/A |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source is OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | N/A |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_Oracle -> OB_Oracle
The following table lists the supported DDL statements for synchronization when you migrate data between Oracle-compatible tenants of OceanBase Database. For more information, see Synchronize DDL operations between Oracle-compatible tenants of OceanBase Database.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source and target are MySQL-compatible tenants of OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | N/A |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_MySQL -> DataHub (BLOB)
The following table lists the supported DDL statements for synchronization when you migrate data from a MySQL-compatible tenant of OceanBase Database to a DataHub instance (of the BLOB type).
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A
NoteIn delayed deletion, the same transaction contains two identical |
Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_Oracle -> DataHub (BLOB)
The following table lists the supported DDL statements for synchronization when you migrate data from an Oracle-compatible tenant of OceanBase Database to a DataHub instance (of the BLOB type).
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source and target are MySQL-compatible tenants of OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | N/A |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_MySQL -> Kafka
The following table lists the supported DDL statements for synchronization when you migrate data from a MySQL-compatible tenant of OceanBase Database to a Kafka instance.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | No |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | Yes |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | No |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source and target are MySQL-compatible tenants of OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | Yes |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |
OB_Oracle -> Kafka
The following table lists the supported DDL statements for synchronization when you migrate data from an Oracle-compatible tenant of OceanBase Database to a Kafka instance.
| Object type | DDL type | DDL statement | Supported |
|---|---|---|---|
| Tables | CREATE | CREATE TABLE A | Yes |
| Tables | CREATE | CREATE TABLE A LIKE B | Yes |
| Tables | CREATE | CREATE TABLE IF NOT EXISTS A | Yes |
| Tables | CREATE | CREATE TABLE AS SELECT | No |
| Tables | ALTER | ALTER TABLE A RENAME B | Yes |
| Tables | ALTER | ALTER TABLE A ADD COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A DROP COLUMN B | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN SET DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A ALTER COLUMN DROP DEFAULT | Yes |
| Tables | ALTER | ALTER TABLE A CHANGE COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A MODIFY COLUMN | Yes |
| Tables | ALTER | ALTER TABLE A ADD INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A DROP INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD FULLTEXT INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD UNIQUE INDEX/KEY B | N/A |
| Tables | ALTER | ALTER TABLE A ADD CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP CONSTRAINT B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PRIMARY KEY | Yes
NoteThis statement is supported only when the source and target are MySQL-compatible tenants of OceanBase Database V4.0.0 or later. |
| Tables | ALTER | ALTER TABLE A ADD PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A DROP PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A TRUNCATE PARTITION B | Yes |
| Tables | ALTER | ALTER TABLE A PARTITION BY... | N/A |
| Tables | DROP | DROP TABLE A | Yes |
| Tables | RENAME | RENAME TABLE A TO B | Yes |
| Tables | TRUNCATE | TRUNCATE TABLE A | Yes |
| Indexes | CREATE | CREATE INDEX A ON B(C) | Yes |
| Indexes | CREATE | CREATE UNIQUE INDEX A ON B(C) | Yes |
| Indexes | DROP | DROP INDEX A ON B | Yes |