Re: How to remove an index

[Aman Raheja]

alter table <tabble-name> drop index <index-name>
For details http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html

Aman Raheja

leegold wrote:

>I want to remove the index I made below. I intend to then redo it
>because I forgot to add a third field. How do I remove this index?
>Alter...? Thanks.
>
>
>mysql> ALTER TABLE page
>    ->   ADD FULLTEXT (title),
>    ->   ADD FULLTEXT (descrip),
>    ->   ADD FULLTEXT (title, descrip);
>Query OK, 1 row affected (0.05 sec)
>Records: 1  Duplicates: 0  Warnings: 0
>
>  
>