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 ALTER ANY TEXT CONFIGURATION or ALTER ANY OBJECT system privilege, or as the owner of the text configuration object.
  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';