Modifying the Stoplist Using Interactive SQL

Modify the stoplist, which 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. Execute an ALTER TEXT CONFIGURATION statement with the STOPLIST clause.

To add a stoplist to the myTxtConfig configuration object:

ALTER TEXT CONFIGURATION myTxtConfig
	STOPLIST 'because about therefore only';
Parent topic: Text Configuration Objects