Name
DROP INDEX
Synopsis
DROP INDEXindex
ONtable
This statement deletes a given
index from a table. To determine the name of a particular index, use
the SHOW INDEX
statement. The key name for the
index found in the results of that statement is used with this
statement.
DROP INDEX client_name ON contacts;
This statement drops the index with the key name of client_name from the contacts table.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.