Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data » Text indexes

 

Alter a text index

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

♦  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. See ALTER TEXT INDEX statement.

♦  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. See ALTER TEXT INDEX statement.

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1