drop_index man page on IRIX

Man page or keyword search:  
man Server   31559 pages
apropos Keyword Search (all sections)
Output format
IRIX logo
[printable version]



     DROP INDEX(l)SQL - Language Statements (2002-11-22) DROP INDEX(l)

     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(l)] 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 definitions in the SQL92 language.

     Page 1					     (printed 3/24/03)

[top]

List of man pages available for IRIX

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net