Alter full-text index
Changing full-text index layout requires complete index re-creation. In order to do so, follow the sequence of the steps:
- Unlink the full-text table <a>Unlinking full-text index</a>
- Drop index <a>Removing full-text index</a>
- Create new full-text index <a>create full-text index</a>
- And finally, link with the DB table using “ALTER TABLE” command <a>linking full-text index with DB table</a>