A text index is dependent on the text configuration object used to create it. So, you must truncate dependent text indexes before you can alter a text configuration object. Since an IMMEDIATE REFRESH text index cannot be truncated, you must drop it before you can alter the text configuration object.

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.

2. 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. Connect to the database as a user with DBA authority, or as owner of the text configuration object.

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

• Full text searching
• Text configuration object settings
• Example text configuration objects
• View text configuration objects in the database
• CREATE TEXT CONFIGURATION statement
• ALTER TEXT CONFIGURATION statement
• Default text configuration objects