Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP TABLESPACE

Delete the tablespace.

Synopsis

DROP TABLESPACE [IF EXISTS] tablespacename

Description

DROP TABLESPACE Deletes tablespace from the system.

Tablespaces can only be deleted by their owner or superuser. All database objects in the tablespace must be empty before deleting the tablespace. Even if no objects in the current database are using the tablespace, objects in other databases may still reside in the tablespace.

Parameters

IF EXISTS

  • If the tablespace does not exist, please do not report an error. In this case, a notification will be issued.

tablespacename

  • The name of the tablespace to be deleted.

Example

Delete tablespace mystuff:

DROP TABLESPACE mystuff;

Compatibility

DROP TABLESPACE is a YMatrix database extension.

See also

ALTER TABLESPACE , CREATE TABLESPACE

← Previous
DROP_TABLE
Next →
DROP_TEXT_SEARCH_CONFIGURATION