All Products
Search
Document Center

DROP TABLESPACE

Last Updated: Jun 18, 2021

Description

The DROP TABLESPACE statement deletes a tablespace logical object. The object can be deleted only if no table exists under the tablespace.

Syntax

DROP TABLESPACE tablespace_name;

Parameter description

Parameter

Description

tablespace_name

Specifies the name of the tablespace to be deleted.

Examples

  • Delete the tablespace object ts.

OceanBase(root@oceanbase)>drop tablesapce ts;