To refresh 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 Refresh Data.

   The Refresh Data window appears.

4. Select an isolation level for the refresh and click OK.

To refresh a text index (SQL)

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. Execute a REFRESH TEXT INDEX statement.

   For example, the following statement refreshes a text index called txt_index_manual on the Description column of the Products table in the demo database:

   REFRESH TEXT INDEX txt_index_manual ON Products;