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 ALTER ANY INDEX or ALTER ANY OBJECT system privilege or as the owner of the underlying table.
2. Execute an ALTER TEXT INDEX statement.

ALTER TEXT INDEX MyTxtIdx 
	ON Customers 
RENAME AS MyTextIndex;