DROP INVERTED INDEX

Introduced or updated: v1.2.405

ENTERPRISE EDITION FEATURE

INVERTED INDEX is an Enterprise Edition feature. Contact Databend Support for a license.

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;