How to alter a text configuration object

A text index is dependent on the text configuration object used to create it so you must be sure to truncate or drop dependent text indexes. Also, if you intend to change the date or time format options that are saved for the text configuration object, you must connect to the database with the options set to the desired settings.

 To alter a text configuration object (SQL)

  1. Connect to the database as a user with DBA authority, or as owner of the text configuration object. If you intend to change the date and time format options for the text configuration object, ensure you connect to the database with the options set to the desired values.

  2. Truncate text indexes that are dependent on the text configuration object. If a text index is defined as IMMEDIATE REFRESH, you must drop it instead.

  3. Execute an ALTER TEXT CONFIGURATION statement. For example, the following statement alters the minimum term length for the myTxtConfig text configuration object: 

    ALTER TEXT CONFIGURATION myTxtConfig
MINIMUM TERM LENGTH 2;
 To alter a text configuration object (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the text configuration object. If you intend to change the date and time format options for the text configuration object, ensure you connect to the database with the options set to the desired values.

  2. In the left pane, click Text Configuration Objects.

  3. Right-click the text configuration object and choose Properties.

  4. Edit the text configuration object properties and click OK.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0