Unix/Linux Go Back    


RedHat 9 (Linux i386) - man page for drop_index (redhat section 7)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


DROP INDEX(7)				   SQL Commands 			    DROP INDEX(7)

NAME
       DROP INDEX - remove an index

SYNOPSIS
       DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]

   INPUTS
       index_name
	      The name (optionally schema-qualified) of an index to remove.

       CASCADE
	      Automatically drop objects that depend on the index.

       RESTRICT
	      Refuse to drop the index if there are any dependent objects.  This is the default.

   OUTPUTS
       DROP INDEX
	      The message returned if the command completes successfully.

       ERROR: index "index_name" does not exist
	      This message occurs if index_name is not an index in the database.

DESCRIPTION
       DROP  INDEX  drops an existing index from the database system. To execute this command you
       must be the owner of the index.

   NOTES
       DROP INDEX is a PostgreSQL language extension.

       Refer to CREATE INDEX [create_index(7)] for information on how to create indexes.

USAGE
       This command will remove the title_idx index:

	   DROP INDEX title_idx;

COMPATIBILITY
   SQL92
       SQL92 defines commands by which to access a generic relational database.  Indexes  are  an
       implementation-dependent feature and hence there are no index-specific commands or defini-
       tions in the SQL92 language.

SQL - Language Statements		    2002-11-22				    DROP INDEX(7)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 03:12 PM.