Altering a Text Configuration Using Interactive SQL

Change the settings of the text configuration object, including the dbspace and permitted term lengths range.

You can alter only text configuration objects that are not being used by a TEXT index.

Connect to the database as a user with DBA or RESOURCE authority, or as the owner of the text configuration object.
Execute an ALTER TEXT CONFIGURATION statement.

To alter the minimum term length for the myTxtConfig text configuration object:

ALTER TEXT CONFIGURATION myTxtConfig 
	MINIMUM TERM LENGTH 2;