Editing a TEXT index

Change the settings for the TEXT index, including the dbspace and TEXT index name.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. In the left pane, select the Text Indexes folder.

3. In the list of Text Indexes, right-click the object to modify and select Properties.

4. On the General tab, modify the settings as needed.

5. Click OK.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. Execute an ALTER TEXT INDEX statement.

   For example, to rename the myTxtIdx to MyTextIndex, enter:

   ALTER TEXT INDEX MyTxtIdx 
   	ON Customers 
   RENAME AS MyTextIndex;