Purpose
You can use this statement to drop a tablespace that contains no tables.
Required privileges
To execute the DROP TABLESPACE statement, you must have the CREATE TABLESPACE privilege. For more information about privileges in OceanBase Database, see Privilege types in MySQL mode.
Syntax
DROP TABLESPACE tablespace_name
[ENGINE [=] engine_name];
Parameters
| Parameter | Description |
|---|---|
| tablespace_name | The name of the tablespace to be dropped. |
| ENGINE | The type of the storage engine that uses the tablespace. In the current version, only the keyword syntax is supported. The functionality does not actually take effect. |
Examples
Drop the tablespace001 tablespace.
DROP TABLESPACE tablespace001;