DROP TEXT INDEX Statement

Removes a TEXT index from the database.

Syntax

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

Examples

– Create and drop the TextIdx TEXT index:
CREATE TEXT INDEX TextIdx ON Customers ( Street ); DROP TEXT INDEX TextIdx ON Customers;

Usage
Use DROP TEXT INDEX to remove a TEXT index from the database.

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

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

Side Effects:
Automatic commit.

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