Purpose
You can use this statement to drop a tablespace that contains no tables.
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 tablespace tablespace001.
DROP TABLESPACE tablespace001;