To alter the refresh type for a text index (Sybase Central)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which the text index is built.

2. In the left pane, click Text Indexes.

3. Right-click the text index and choose Properties.

4. Edit the text index properties and click OK.

To alter the refresh type for a text index (SQL)

1. Connect to the database as a user with DBA authority, or as the owner of the text index.

2. Execute an ALTER TEXT INDEX statement.

   For example, the following statement changes the txt_index_manual text index to refresh every 6 hours.

   ALTER TEXT INDEX txt_index_manual ON Products AUTO REFRESH EVERY 6 HOURS;

To rename a text index (Sybase Central)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which the text index is built.

2. In the left pane, click Text Indexes.

3. Right-click the text index and choose Properties.

4. Click the General tab and type a new name for the text index.

5. Click OK.

To rename a text index (SQL)

1. Connect to the database as a user with DBA authority, or as the owner of the text index.

2. Execute an ALTER TEXT INDEX statement.

   For example, the following statement renames the txt_index_manual text index to new_txt_index.

   ALTER TEXT INDEX txt_index_manual ON Products RENAME AS new_txt_index;