Editing a TEXT Index Using Interactive SQL

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. Execute an ALTER TEXT INDEX statement.

To rename the TEXT index myTxtIdx to MyTextIndex:

ALTER TEXT INDEX MyTxtIdx 
	ON Customers 
RENAME AS MyTextIndex;
Parent topic: TEXT Indexes