- 13.1 Data Definition Statements
- 13.1.1 ALTER DATABASE Syntax
- 13.1.2 ALTER TABLE Syntax
- 13.1.3 ALTER LOGFILE GROUP Syntax
- 13.1.4 ALTER TABLESPACE Syntax
- 13.1.5 ALTER SERVER Syntax
- 13.1.6 CREATE DATABASE Syntax
- 13.1.7 CREATE INDEX Syntax
- 13.1.8 CREATE TABLE Syntax
- 13.1.9 CREATE LOGFILE GROUP Syntax
- 13.1.10 CREATE TABLESPACE Syntax
- 13.1.11 CREATE SERVER Syntax
- 13.1.12 DROP DATABASE Syntax
- 13.1.13 DROP INDEX Syntax
- 13.1.14 DROP TABLE Syntax
- 13.1.15 DROP LOGFILE GROUP Syntax
- 13.1.16 DROP TABLESPACE Syntax
- 13.1.17 DROP SERVER Syntax
- 13.1.18 RENAME DATABASE Syntax
- 13.1.19 RENAME TABLE Syntax
DROP TABLESPACEtablespaceENGINE [=]engine
This statement drops a tablespace that was previously created
using CREATE TABLESPACE (see
Section 13.1.10, “CREATE TABLESPACE Syntax”).
Important: The tablespace to be
dropped must not contain any data files; in other words, before
you can drop a tablespace, you must first drop each of its data
files using ALTER TABLESPACE ... DROP
DATAFILE (see Section 13.1.4, “ALTER TABLESPACE Syntax”).
The ENGINE clause (required) specifies the
storage engine used by the tablespace. In MySQL 5.1, the only
accepted values for engine are
NDB and NDBCLUSTER.
DROP TABLESPACE was added in MySQL 5.1.6. In
MySQL 5.1, it is useful only with Disk Data storage for MySQL
Cluster. See Section 15.11, “MySQL Cluster Disk Data Tables”.
User Comments
Add your own comment.