MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.20 DROP INDEX Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER FUNCTION Syntax
- 12.1.4 ALTER PROCEDURE Syntax
- 12.1.5 ALTER SERVER Syntax
- 12.1.6 ALTER TABLE Syntax
- 12.1.7 ALTER VIEW Syntax
- 12.1.8 CREATE DATABASE Syntax
- 12.1.9 CREATE EVENT Syntax
- 12.1.10 CREATE FUNCTION Syntax
- 12.1.11 CREATE INDEX Syntax
- 12.1.12 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.13 CREATE SERVER Syntax
- 12.1.14 CREATE TABLE Syntax
- 12.1.15 CREATE TRIGGER Syntax
- 12.1.16 CREATE VIEW Syntax
- 12.1.17 DROP DATABASE Syntax
- 12.1.18 DROP EVENT Syntax
- 12.1.19 DROP FUNCTION Syntax
- 12.1.20 DROP INDEX Syntax
- 12.1.21 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.22 DROP SERVER Syntax
- 12.1.23 DROP TABLE Syntax
- 12.1.24 DROP TRIGGER Syntax
- 12.1.25 DROP VIEW Syntax
- 12.1.26 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.6, “ALTER TABLE Syntax”.
User Comments
Add your own comment.