Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Full text search » Full text search tasks


Refreshing a text index

Administrators can refresh text indexes in Sybase Central to update the data in the text index. Refreshing a text index causes it to reflect any data changes that have occurred in the underlying table.


You must have DBA authority or be the owner of the table on which the text index is built.

You can only refresh text indexes that are defined as AUTO REFRESH and MANUAL REFRESH.

Context and remarks


 Refresh a text index (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, click Text Indexes.

  3. Right-click the text index and click Refresh Data.

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


The text index is refreshed.



 See also