DROP TEXT INDEX statement

Description

Removes a TEXT index from the database.

Syntax

DROP TEXT INDEXtext-index-name
   ON[ owner ] table-name

Examples

Example 1

These statements create and drop 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.

Automatic commit

Permissions

Must be the owner of the underlying table, or have DBA authority, or have REFERENCES permission.