Drops a specified index from a table.
Parameters
$table
stringrequired- Database table name.
$index
stringrequired- Index name to drop.
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;
}
Changelog
Version | Description |
---|---|
1.0.1 | Introduced. |
User Contributed Notes
You must log in before being able to contribute a note or feedback.