Modifying the stoplist

The stoplist contains a list of terms to ignore when building a TEXT index with this text configuration. You can alter only text configuration objects that are not being used by a TEXT index.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. In the left pane, select Text Configurations Objects.

3. In the list of Text Configurations, right-click the object to modify and select Properties.

4. Switch to the Stoplist tab, and modify the stoplist words as needed. Use a space to separate the terms.

5. To sort the list of stoplist terms alphabetically and show them in a list, click Sort Terms.

6. When the stoplist is updated, click OK.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. Execute a ALTER TEXT CONFIGURATION statement with the STOPLIST clause.

   For example, to add a stoplist to the myTxtConfig configuration object, use:

   ALTER TEXT CONFIGURATION myTxtConfig
   	STOPLIST 'because about therefore only';