DROP INDEX

Removes an index from a table.

Syntax

DROP INDEX [ IF EXISTS ] <name> ON <table_name>

Parameters

<name>

The name of the index to drop.

<table_name>

The name of the table containing the index.

Examples

DROP INDEX idx_log_id ON logs;
DROP INDEX IF EXISTS idx_log_message ON logs;