DROP TABLESPACE

Function Description

Deletes a tablespace.

Precautions

Compared with the original MogDB, Dolphin modifies the DROP TABLESPACE syntax as follows:

The ENGINE [=] engine_name option is added for syntax compatibility only.

Syntax

DROP TABLESPACE [ IF EXISTS ] tablespace_name [ENGINE [=] engine_name];

Parameter Description

• IF EXISTS

  Sends a notice instead of an error if the specified tablespace does not exist.

• tablespace_name

  Indicates the name of tablespace.

  Value range: an existing tablespace name

• engine_name

  This parameter is meaningless.

  Value: a combination of any characters

Examples

For details, see CREATE TABLESPACE.

Helpful Links

ALTER TABLESPACE, CREATE TABLESPACE