Modifying the TEXT Index Location Using Sybase Central

Change the dbspace where the TEXT index is stored.

1. Connect to the database as a user with DBA or SPACE ADMIN authority or as table owner with CREATE privilege on dbspace.
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, select the dbspace from the drop-down list.
5. When the dbspace is updated, click OK.