- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER LOGFILE GROUP Syntax
- 12.1.3 ALTER SERVER Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER TABLESPACE Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE INDEX Syntax
- 12.1.8 CREATE LOGFILE GROUP Syntax
- 12.1.9 CREATE SERVER Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TABLESPACE Syntax
- 12.1.12 DROP DATABASE Syntax
- 12.1.13 DROP INDEX Syntax
- 12.1.14 DROP LOGFILE GROUP Syntax
- 12.1.15 DROP SERVER Syntax
- 12.1.16 DROP TABLE Syntax
- 12.1.17 DROP TABLESPACE Syntax
- 12.1.18 RENAME TABLE Syntax
DROP TABLESPACEtablespace_nameENGINE [=]engine_name
This statement drops a tablespace that was previously created
using CREATE TABLESPACE (see
Section 12.1.11, “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 12.1.5, “ALTER TABLESPACE Syntax”).
The ENGINE clause (required) specifies the
storage engine used by the tablespace. The only accepted values
for engine_name are
NDB, NDBCLUSTER and
Falcon.
For more information on using DROP TABLESPACE
with Disk Data storage for MySQL Cluster, see
MySQL Cluster Disk Data Tables. For information on
using DROP TABLESPACE with Falcon, see
Section 13.6.4, “Creating Tables and Indexes within Falcon”."
User Comments
Add your own comment.