[CentOS] OT: MySQL Help

Wed May 10 01:37:08 UTC 2006
Alan Sparks <asparks at doublesparks.net>

Thomas E Dukes wrote:
> I ran the following against a table:
> ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
> Can this index be removed?  If so, how?

DROP INDEX `idx_products_model`
ALTER TABLE `products` DROP INDEX `idx_products_model`

Alan Sparks, UNIX/Linux Systems Integration and Administration
<asparks at doublesparks.net>