drop_index() │ WP 1.0.1

Drops a specified index from a table.

No Hooks.

Return

true. True, when finished.

Usage

drop_index( $table, $index );

$table(string) (required)

Database table name.

$index(string) (required)

Index name to drop.

Notes

• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

drop_index() drop index code ^{WP 6.5.2}

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;
}