Altering text indexes

You can change the name of a text index, or change its refresh type, in Sybase Central.

Prerequisites

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

Context and remarks

You cannot alter a text index to refer to a different text configuration object. If you want a text index to refer to another text configuration object, drop the text index and recreate it specifying the new text configuration object.

 Alter the refresh type for 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 Properties.

  4. Edit the text index properties and click OK.

 Rename 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 Properties.

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

  5. Click OK.

Results

The refresh type is altered and the text index is renamed.

Next

None.

 See also