DROP TABLE - ApsaraDB for OceanBase - Alibaba Cloud Documentation Center

This topic describes the conversion scope of DROP TABLE DDL operations during data migration from an Oracle database to an Oracle tenant of OceanBase Database.

Syntax

DROP TABLE [ schemaName. ] tableName
  [ CASCADE CONSTRAINTS ] [ PURGE ] ;

Supported operations

Dropping a single table is supported.
Dropping all foreign key constraints that refer to the primary and unique keys defined on the dropped table is supported. You can perform this operation by specifying the CASCADE CONSTRAINTS clause. Sample code:
```
DROP TABLE T CASCADE CONSTRAINTS
```

Ignored clauses and options

Note

The following clauses and options will be ignored and will not be resolved or converted when they are specified in the synchronized DDL statements.

The PURGE clause for instructing the database to immediately release the space associated with the dropped table.