Previous Next JavaScript must be enabled to correctly display this content

## Deleting a Full Text Index

To delete a Full Text Index created on an Oracle NoSQL table, you can use the NoSQL store's Admin CLI to execute a command with the following format:

    execute 'DROP INDEX [IF EXISTS] <index> ON <table>';

Each argument, flag, and directive is described as follows, where any item encapsulated by square brackets `[...]` is optional:

- index - The name of the Text Index to delete.
- table - The name of the table containing the indexed fields.

If the command above is executed and a Text Index with the specified name does not exist, then the command will fail, displaying an error message. Specifying `IF EXISTS` when the named index does not exist will result in a no-op.

Note:

The command above, when applied to a Full Text Index, will not only remove all metadata related to the index from the associated Oracle NoSQL store's state, but will also remove the corresponding data indexed in Elasticsearch.