- 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 LOGFILE GROUPlogfile_groupENGINE [=]engine
This statement drops the log file group named
logfile_group. The log file group
must already exist or an error results. (For information on
creating log file groups, see
Section 13.1.9, “CREATE LOGFILE GROUP Syntax”.)
Important: Before dropping a
log file group, you must drop all tablespaces that use that log
file group for UNDO logging.
The required ENGINE clause provides the name
of the storage engine used by the log file group to be dropped.
In MySQL 5.1, the only permitted values for
engine are NDB and
NDBCLUSTER.
DROP LOGFILE GROUP 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.