drop_index() WordPress Function
The drop_index() function is used to remove an index from a WordPress database table. It takes two arguments: the name of the table and the name of the index.
drop_index( string $table, string $index ) #
Drops a specified index from a table.
Parameters
- $table
(string)(Required)Database table name.
- $index
(string)(Required)Index name to drop.
Return
(true) True, when finished.
Source
File: wp-admin/includes/upgrade.php
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 full source codeCollapse full source codeView on TracView on GitHub
Changelog
| Version | Description |
|---|---|
| 1.0.1 | Introduced. |