DROP TEXT CONFIGURATION [ owner.]text-config-name

Attempting to drop a text configuration object with dependent text indexes results in an error. You must drop the dependent text indexes before dropping the text configuration object.

Text configuration objects are stored in the ISYSTEXTCONFIG system table.

Must be the owner of the text configuration object or have DBA authority.

Automatic commit

• DROP TEXT INDEX statement
• Full text search
• Text configuration object concepts and reference
• SYSTEXTCONFIG system view
• CREATE TEXT CONFIGURATION statement
• ALTER TEXT CONFIGURATION statement

The following statements create and drop the mytextconfig text configuration object:

CREATE TEXT CONFIGURATION mytextconfig FROM default_char;
DROP TEXT CONFIGURATION mytextconfig;