Re: How to remove an index

alter table drop index 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 -> A

How to remove an index

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 af