GNU Info

(mysql.info)DROP INDEX

---

Prev: CREATE INDEX Up: Data Definition

---

Enter node , (file) or (file)node

`DROP INDEX' Syntax
-------------------

     DROP INDEX index_name ON tbl_name

`DROP INDEX' drops the index named `index_name' from the table
`tbl_name'.  `DROP INDEX' doesn't do anything in MySQL prior to Version
3.22.  In Version 3.22 or later, `DROP INDEX' is mapped to an `ALTER
TABLE' statement to drop the index.  Note: `ALTER TABLE'.