MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual

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

Additional languages

Japanese
Portuguese

MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.7 DROP INDEX Syntax

« 12.1.6 DROP DATABASE Syntax

12.1.8 DROP TABLE Syntax »

Section Navigation [Toggle]

12.1 Data Definition Statements
12.1.1 ALTER DATABASE Syntax
12.1.2 ALTER TABLE Syntax
12.1.3 CREATE DATABASE Syntax
12.1.4 CREATE INDEX Syntax
12.1.5 CREATE TABLE Syntax
12.1.6 DROP DATABASE Syntax
12.1.7 DROP INDEX Syntax
12.1.8 DROP TABLE Syntax
12.1.9 RENAME TABLE Syntax

12.1.7. `DROP INDEX` Syntax

DROP INDEX index_name ON tbl_name

DROP INDEX drops the index named index_name from the table tbl_name. In MySQL 3.22 or later, DROP INDEX is mapped to an ALTER TABLE statement to drop the index. See Section 12.1.2, “ALTER TABLE Syntax”. DROP INDEX does not do anything prior to MySQL 3.22.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

12.1.7. DROP INDEX Syntax

User Comments

12.1.7. `DROP INDEX` Syntax