DROP NGRAM INDEX

Introduced or updated: v1.2.726

Drops an existing NGRAM index from a table.

Syntax

DROP NGRAM INDEX [IF EXISTS] <index_name>
ON [<database>.]<table_name>;

Examples

The following example drops the idx1 index from the amazon_reviews_ngram table:

DROP NGRAM INDEX idx1 ON amazon_reviews_ngram;