DROP TEXT CONFIGURATION statement

Drops a text configuration object.

Syntax

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

Remarks

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.

Privileges

You must be the owner of the text configuration object, or have the DROP ANY TEXT CONFIGURATION or DROP ANY OBJECT system privilege.

Side effects

Automatic commit

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

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

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