DROP TEXT CONFIGURATION Statement

Note: This statement requires the Unstructured Data Analytics (IQ_UDA) license.

Quick Links:

Syntax

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

Examples

(back to top)

Example 1 – creates and drops the mytextconfig text configuration object:
```
CREATE TEXT CONFIGURATION mytextconfig FROM default_char;
DROP TEXT CONFIGURATION mytextconfig;
```

Usage

(back to top)

Use DROP TEXT CONFIGURATION to drop a text configuration object.

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.

Side Effects:

Automatic commit.

Permissions

(back to top)

Text configuration object owned by self – None required.

Table configuration object owned by any user – Requires one of:

DROP ANY TEXT CONFIGURATION system privilege.
DROP ANY OBJECT system privilege.