DROP TABLESPACE

2023-10-31 11:17:11  Updated

Purpose

You can use this statement to drop a tablespace without tables.

Syntax

DROP TABLESPACE tablespace_name;

Parameters

Parameter Description
tablespace_name The name of the tablespace to be dropped.

Examples

Drop the tablespace tblspace1.

obclient>  DROP TABLESPACE tblspace1;
Query OK, 0 rows affected

Contact Us