www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Free Text Search

Basic Concepts
Creating Free Text Indexes
Querying Free Text Indexes
Text Triggers
Generated Tables and Internals
Removing A Text Index
Removing A Text Trigger
Internationalization & Unicode
Performance
Free Text Functions

18.6. Removing A Text Index

A text index is dropped by dropping the words table with DROP TABLE. This will drop all triggers, procedures and auxiliary tables. The words table is in the qualifier and owner of the indexed table and is named <table>_<column>_WORDS.

Example
drop table DB.DBA.XML_TEXT_XT_TEXT_WORDS;

-- drops the text index created in the vt_create_text_index example