Page 1 of 1

How do I remove FULLTEXT?

Posted: Sat Jun 23, 2012 9:25 pm
by wvoyance
I miss-clicked phpMySQL a button for FULLTEXT which generate an SQL
ALTERTABLE`products`ADDFULLTEXT (....
To my understanding that will make an index for the whole field and made the database slow.
How can I remove it? Thanks.

Re: How do I remove FULLTEXT?

Posted: Sun Jun 24, 2012 12:01 am
by requinix
phpMyAdmin? Surely it allows for you to delete indexes on tables. Take a look.

Re: How do I remove FULLTEXT?

Posted: Sun Jun 24, 2012 12:24 am
by wvoyance
how? click again? seems no use.

Re: How do I remove FULLTEXT?

Posted: Sun Jun 24, 2012 1:13 am
by requinix
LOOK. If you don't know then Google it.

Re: How do I remove FULLTEXT?

Posted: Sun Jun 24, 2012 3:10 am
by wvoyance
got it ... hope it is correct :P

Re: How do I remove FULLTEXT?

Posted: Tue Jul 03, 2012 7:42 am
by joevega
Expand a server group, and then expand a server. Expand Databases, expand the database in which the table belongs, and then click Tables.In the details pane, right-click the table, click Full-Text Index Table, and then click Remove Full-Text Indexing.Click Yes to confirm the removal of the full-text index from the table.