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.
drop table DB.DBA.XML_TEXT_XT_TEXT_WORDS;
-- drops the text index created in the vt_create_text_index example
Previous
Generated Tables and Internals |
Chapter Contents |
Next
Removing A Text Trigger |