Title: drop_index
Published: April 25, 2014
Last modified: February 24, 2026

---

# drop_index( string $table, string $index ): true

## In this article

 * [Parameters](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#parameters)
 * [Return](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#return)
 * [Source](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#source)
 * [Related](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#related)
 * [Changelog](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#changelog)

[ Back to top](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#wp--skip-link--target)

Drops a specified index from a table.

## 󠀁[Parameters](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#parameters)󠁿

 `$table`stringrequired

Database table name.

`$index`stringrequired

Index name to drop.

## 󠀁[Return](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#return)󠁿

 true True, when finished.

## 󠀁[Source](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#source)󠁿

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

[View all references](https://developer.wordpress.org/reference/files/wp-admin/includes/upgrade.php/)
[View on Trac](https://core.trac.wordpress.org/browser/tags/6.9.4/src/wp-admin/includes/upgrade.php#L2686)
[View on GitHub](https://github.com/WordPress/wordpress-develop/blob/6.9.4/src/wp-admin/includes/upgrade.php#L2686-L2701)

## 󠀁[Related](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#related)󠁿

| Uses | Description | 
| [wpdb::query()](https://developer.wordpress.org/reference/classes/wpdb/query/)`wp-includes/class-wpdb.php` |

Performs a database query, using current database connection.

  | 
| [wpdb::hide_errors()](https://developer.wordpress.org/reference/classes/wpdb/hide_errors/)`wp-includes/class-wpdb.php` |

Disables showing of database errors.

  | 
| [wpdb::show_errors()](https://developer.wordpress.org/reference/classes/wpdb/show_errors/)`wp-includes/class-wpdb.php` |

Enables showing of database errors.

  |

| Used by | Description | 
| [add_clean_index()](https://developer.wordpress.org/reference/functions/add_clean_index/)`wp-admin/includes/upgrade.php` |

Adds an index to a specified table.

  |

## 󠀁[Changelog](https://developer.wordpress.org/reference/functions/drop_index/?output_format=md#changelog)󠁿

| Version | Description | 
| [1.0.1](https://developer.wordpress.org/reference/since/1.0.1/) | Introduced. |

## User Contributed Notes

You must [log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fdeveloper.wordpress.org%2Freference%2Ffunctions%2Fdrop_index%2F)
before being able to contribute a note or feedback.