May 2005
Intermediate to advanced
352 pages
14h 39m
English
DROP INDEX
DROP INDEXindexONtable
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.
Read now
Unlock full access