The SQL keyword DROP INDEX is used to delete an existing index permanently from a database.
Here is the syntax to drop an index on different database systems.
| Database System | Syntax |
| MySQL | ALTER TABLE table_name DROP INDEX index_name; |
| SQL Server | DROP INDEX table_name.index_name; |
| Oracle / DB2 | DROP INDEX index_name; |
| MS Access | DROP INDEX index_name ON table_name; |
If you find the content useful and like to share it with others, you can click the below link to share on social platforms.
The content can be shared on most of the popular social networking platforms.
Your feedback and suggestions are important to us, as they help us grow stronger.
If you wish to share your feedback or suggestions, you can write to us at the below email address.
We have some interesting and useful online tools that can be used to perform some of the tasks that we struggle to do on a daily basis.
You can take a look and make use of them to simplify your software development and testing.
We have some interesting and useful online tools that can be used to perform some of the tasks that we struggle to do on a daily basis.
You can take a look and make use of them to simplify your software development and testing.
We publish some useful content on YouTube on a regular basis, which will be useful for you.
You can take a look and subscribe to the YouTube channel if you wish to receive updates on videos we publish on YouTube.
You can also share your feedback and suggestions on YouTube in the form of like, share, comment and subscription.