Remove an Index

Learn how to remove an index.

We can remove an index by using the drop index command, as in the following example:

drop index customers_identity_idx on customers;

Parts of drop index query

As always, let’s look at its constituent parts.

Get hands-on with 1200+ tech skills courses.