wpseek.com
A WordPress-centric search engine for devs and theme authors



drop_index › WordPress Function

Since1.0.1
Deprecatedn/a
› drop_index ( $table, $index )
Parameters: (2)
  • (string) $table Database table name.
    Required: Yes
  • (string) $index Index name to drop.
    Required: Yes
Returns:
  • (true) True, when finished.
Defined at:
Codex:

Drops a specified index from a table.



Related Functions: noindex, get_dropins, add_clean_index, _get_dropins, do_action

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