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
Answertopia.com

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

  




 

 

DROP INDEX

Name

DROP INDEX -- Removes an index from a database.

Synopsis

DROP INDEX index_name [, ...]

Parameters

index_name

The name of the index you wish to remove from the database.

Results

DROP

The message returned if the index is removed successfully.

ERROR: index "index_name" does not exist

The error returned if the specified index cannot be found within the database.

Description

The owner of an index may remove it from the database by using this command.

Example

The following example drops an index called customer_id_idx from the booktown database:

booktown=# DROP INDEX customer_id_idx;
DROP

The next example drops two indices simultaneously from the booktown database:

booktown=# DROP INDEX books_id_pkey, books_title_idx;
DROP

 
 
  Published courtesy of O'Reilly Design by Interspire