DROP TEXT INDEX Statement

Syntax

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

Examples

• Example 1 – 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.

Permissions

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