Removes a text index from the database.

Syntax

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

Parameters

Remarks

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

Permissions

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

This statement cannot be executed when there are cursors opened with the WITH HOLD clause that use either statement or transaction snapshots. See Snapshot isolation.

Side effects

Automatic commit

See also

• Full text searching
• Text indexes
• SYSTEXTCONFIG system view
• CREATE TEXT INDEX statement
• ALTER TEXT INDEX statement
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE TEXT INDEX statement

Standards and compatibility

Example

The following statements create and drop the TextIdx text index:

CREATE TEXT INDEX TextIdx ON MarketingInformation ( Description )
DROP TEXT INDEX TextIdx ON MarketingInformation;