:: DEVELOPER ZONE
MySQL Reference Manual :: 13.1.7 DROP INDEX Syntax
Search the MySQL manual:
- 13.1 Data Definition Statements
- 13.1.1 ALTER DATABASE Syntax
- 13.1.2 ALTER TABLE Syntax
- 13.1.3 CREATE DATABASE Syntax
- 13.1.4 CREATE INDEX Syntax
- 13.1.5 CREATE TABLE Syntax
- 13.1.6 DROP DATABASE Syntax
- 13.1.7 DROP INDEX Syntax
- 13.1.8 DROP TABLE Syntax
- 13.1.9 RENAME TABLE Syntax
Additional languages
Additional formats
DROP INDEXindex_nameONtbl_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 13.1.2, “ALTER TABLE Syntax”. DROP INDEX doesn't
do anything prior to MySQL 3.22.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.