Dropping a table

Before you drop a table with one or more text indexes, you must issue the following command for each text index:

db2text drop index <index_name> for text

If you accidently drop a table before you drop the indexes, parts of the indexes will still exist, for example, the administration tables and text index files.

To remove these files, drop the indexes using the db2text drop index command, even though the table no longer exists.