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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]