drop_index
Remove an index from a MySQL database table to optimize storage or modify table structure. Specify the table name and index to delete.
Instructions
Drop an index from a table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| indexName | Yes | Index name | |
| database | No | Database name (optional) |