- 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 INDEXindex_nameONtbl_name
DROP INDEX drops the index named
index_name from the table
tbl_name. This statement is mapped to
an ALTER TABLE statement to drop the index. See
Section 12.1.4, “ALTER TABLE Syntax”.
Indexes on variable-width columns are dropped online; that is, dropping the indexes does not require any copying or locking of the table. This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to happen.
In standard MySQL 6.0 releases, it is not possible to
override the server when it determines that an index is to be
dropped online. For more information, see
Section 12.1.4, “ALTER TABLE Syntax”.
User Comments
Add your own comment.