drop_index( string $table, string $index )

Drops a specified index from a table.

Parameters

$table: (Required) Database table name.
$index: (Required) Index name to drop.

Return

(true) True, when finished.

Source

function drop_index($table, $index) {
	global $wpdb;
	$wpdb->hide_errors();
	$wpdb->query("ALTER TABLE `$table` DROP INDEX `$index`");
	// Now we need to take out all the extra ones we may have created
	for ($i = 0; $i < 25; $i++) {
		$wpdb->query("ALTER TABLE `$table` DROP INDEX `{$index}_$i`");
	}
	$wpdb->show_errors();
	return true;
}

Expand Source Code View on GitHub

Changelog

Changelog
Version	Description
1.0.1	Introduced.