Dropping a text index

Summary
When
When you no longer intend to make text searches in a text column.
Command
DROP INDEX FOR TEXT
Authorization
CONTROL on the table

Example:

db2text DROP INDEX comment FOR TEXT

When dropping a text index, you also drop the following tables and views:

Note

Always drop the indexes on the table before dropping the table. If you drop the table first, the indexes still exist.