Question

drop_index( string $table,  string $index )

Drops a specified index from a table.

---

description

---

参数

$table

(string) (Required) Database table name.

$index

(string) (Required) Index name to drop.

---

返回值

(true) True, when finished.

---

源代码

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

---

更新日志

Version	description
1.0.1	Introduced.

---

相关函数

Uses

• wp-includes/wp-db.php: wpdb::query()
• wp-includes/wp-db.php: wpdb::hide_errors()
• wp-includes/wp-db.php: wpdb::show_errors()

---

Used By

• wp-admin/includes/upgrade.php: add_clean_index()

---

User Contributed Notes