W3cubDocs

/WordPress

drop_index( string $table, string $index )

Drops a specified index from a table.

Description

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

Changelog

Version Description
1.0.1 Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/drop_index