DROP INVERTED INDEX

Introduced or updated: v1.2.405

Removes an inverted index in Databend.

Syntax

DROP INVERTED INDEX [IF EXISTS] <index> ON [<database>.]<table>

Examples

-- Drop the inverted index 'customer_feedback_idx' on the 'customer_feedback' table
DROP INVERTED INDEX customer_feedback_idx ON customer_feedback;