DROP TEXT INDEX Statement

Removes a TEXT index from the database.

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

Quick Links:

Go to Parameters

Go to Permissions

Syntax

DROP TEXT INDEX <text-index-name>
   ON [ <owner> ] <table-name>

Parameters

ON specifies the table on which the TEXT index is built.

Examples

Example 1
creates and drops the TextIdx TEXT index:
```
CREATE TEXT INDEX TextIdx ON Customers ( Street );
DROP TEXT INDEX TextIdx ON Customers;
```

Usage

You must drop dependent TEXT indexes before you can drop a text configuration object.

Side Effects:

Automatic commit.

Permissions

Requires one of:

DROP ANY INDEX system privilege.
DROP ANY OBJECT system privilege.
REFERENCES privilege on the table being indexed.
You own the underlying table.