DROP TEXT INDEX Statement

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.

Permissions

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