How do I remove FULLTEXT?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
wvoyance
Forum Contributor
Posts: 135
Joined: Tue Apr 17, 2012 8:24 pm

How do I remove FULLTEXT?

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: How do I remove FULLTEXT?

Post by requinix »

phpMyAdmin? Surely it allows for you to delete indexes on tables. Take a look.
User avatar
wvoyance
Forum Contributor
Posts: 135
Joined: Tue Apr 17, 2012 8:24 pm

Re: How do I remove FULLTEXT?

Post by wvoyance »

how? click again? seems no use.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: How do I remove FULLTEXT?

Post by requinix »

LOOK. If you don't know then Google it.
User avatar
wvoyance
Forum Contributor
Posts: 135
Joined: Tue Apr 17, 2012 8:24 pm

Re: How do I remove FULLTEXT?

Post by wvoyance »

got it ... hope it is correct :P
joevega
Forum Newbie
Posts: 5
Joined: Mon Jun 25, 2012 6:17 am

Re: How do I remove FULLTEXT?

Post 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.
Post Reply