This command drops a full-text index for a text column. If the cache for the index is activated, it is deleted using this command.
Authorization
According to DB2 catalog views, the userid in this command must have the CONTROL privilege on the table the full-text index was created for. Alternatively, the user can be the database administrator (DBADM).
Alternatively, the database administrator (DBADM), can drop the index as they must be able to disable the database using the FORCE option.
Command syntax
>>-DROP-INDEX--+------------------+--index-name--FOR-TEXT-------> '-index-schema-"."-' >--+----------------------+------------------------------------>< '-|connection-options|-' connection-options |--+--------------------------------------------------------------+--| '-CONNECT-TO--database-name--+-------------------------------+-' '-USER--userid--USING--password-'
Command parameters
Usage
The index is deleted, irrespective of the activation status of its cached table. For additional information, see ACTIVATE CACHE for more information.
Note that the command could not be issued when one of the following commands is running on the index:
Note |
---|
Indexes must be manually dropped before or after the user table in DB2 is dropped. If not, the results are not correctly cleaned up. |
When using the replication capture tables, entries in the IBMSNAP_PRUNE_SET and IBMSNAP_PRUNCTRNL tables are removed.