Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

Destroying an Index

The SQL command to permanently destroy an existing index from a table is DROP INDEX. Here is the syntax for DROP INDEX:

  DROP INDEX 
indexname
 [, ...]

In this syntax, indexname is the name of the index that you wish to permanently remove. Multiple indices to drop may be specified, separated by commas.

Example 7-6 drops the upper_title_idx index created in Example 7-5.

Example 7-6. Dropping an index

booktown=# 
DROP INDEX upper_title_idx;

DROP
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire