IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]