drop_index

The timeline below displays how wordpress function drop_index has changed across different WordPress versions. If a version is not listed, refer to the next available version below.

WordPress Version: 5.4

/**
 * Drops a specified index from a table.
 *
 * @since 1.0.1
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param string $table Database table name.
 * @param string $index Index name to drop.
 * @return true True, when finished.
 */
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;
}

WordPress Version: 5.3

/**
 * Drops a specified index from a table.
 *
 * @since 1.0.1
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param string $table Database table name.
 * @param string $index Index name to drop.
 * @return true True, when finished.
 */
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;
}

WordPress Version: 4.3

/**
 * Drops a specified index from a table.
 *
 * @since 1.0.1
 *
 * @global wpdb  $wpdb
 *
 * @param string $table Database table name.
 * @param string $index Index name to drop.
 * @return true True, when finished.
 */
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;
}

WordPress Version: 4.2

/**
 * Drops a specified index from a table.
 *
 * @since 1.0.1
 *
 * @param string $table Database table name.
 * @param string $index Index name to drop.
 * @return bool True, when finished.
 */
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;
}

WordPress Version: 3.7

/**
 * {@internal Missing Short Description}}
 *
 * {@internal Missing Long Description}}
 *
 * @since 1.0.1
 *
 * @param string $table Database table name.
 * @param string $index Index name to drop.
 * @return bool True, when finished.
 */
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;
}