Languages
[Edit]
EN

PostgreSQL - remove index from existing table

3 points
Created by:
Kelly
214

In this article, we would like to show you how to remove an index from the existing table in PostgreSQL.

Quick solution:

ALTER TABLE "table_name"
DROP INDEX "index_name";

or 

DROP INDEX "index_name" ON "table_name";

Practical example

In this example, we will remove the salary_index created in the previous article.

Query:

ALTER TABLE "users"
DROP INDEX "salary_index";

or

DROP INDEX "salary_index" ON "users";

Related posts

PostgreSQL - indexes

Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join