1 files changed, 177 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml
new file mode 100644
index 0000000000..726487356e
--- /dev/null
+++ b/doc/src/sgml/ref/drop_index.sgml
@@ -0,0 +1,177 @@
+<REFENTRY ID="SQL-DROPINDEX">
+ <REFMETA>
+  <REFENTRYTITLE>
+   DROP INDEX
+  </REFENTRYTITLE>
+  <REFMISCINFO>SQL - Language Statements</REFMISCINFO>
+ </REFMETA>
+ <REFNAMEDIV>
+  <REFNAME>
+   DROP INDEX
+  </REFNAME>
+  <REFPURPOSE>
+   Removes an index from a database
+  </REFPURPOSE>
+ <REFSYNOPSISDIV>
+  <REFSYNOPSISDIVINFO>
+   <DATE>1998-04-15</DATE>
+  </REFSYNOPSISDIVINFO>
+  <SYNOPSIS>
+   DROP INDEX <REPLACEABLE CLASS="PARAMETER">index_name</REPLACEABLE>
+  </SYNOPSIS>
+  
+  <REFSECT2 ID="R2-SQL-DROPINDEX-1">
+   <REFSECT2INFO>
+    <DATE>1998-04-15</DATE>
+   </REFSECT2INFO>
+   <TITLE>
+    Inputs
+   </TITLE>
+   <PARA>
+   </PARA>
+   <VARIABLELIST>
+    <VARLISTENTRY>
+     <TERM>
+     </TERM>
+     <LISTITEM>
+      <PARA>
+       <VARIABLELIST>
+	<VARLISTENTRY>
+	 <TERM>
+	  <ReturnValue><REPLACEABLE CLASS="PARAMETER">index_name</REPLACEABLE></ReturnValue>
+	 </TERM>
+	 <LISTITEM>
+	  <PARA>
+	   The name of the index to remove.
+	  </PARA>
+	 </LISTITEM>
+	</VARLISTENTRY>
+       </variablelist>
+     </LISTITEM>
+    </VARLISTENTRY>
+   </VARIABLELIST>
+  </REFSECT2>
+  
+  <REFSECT2 ID="R2-SQL-DROPINDEX-2">
+   <REFSECT2INFO>
+    <DATE>1998-04-15</DATE>
+   </REFSECT2INFO>
+   <TITLE>
+    Outputs
+   </TITLE>
+   <PARA>
+   </PARA>
+   <VARIABLELIST>
+    <VARLISTENTRY>
+     <TERM>
+     </TERM>
+     <LISTITEM>
+      <PARA>
+       <VARIABLELIST>
+	<VARLISTENTRY>
+	 <TERM>
+	  <ReturnValue>DROP</ReturnValue>
+	 </TERM>
+	 <LISTITEM>
+	  <PARA>
+          The message returned if the index is successfully dropped.
+	  </PARA>
+	 </LISTITEM>
+	</VARLISTENTRY>
+	<VARLISTENTRY>
+	 <TERM>
+	  <ReturnValue>ERROR: index "<REPLACEABLE CLASS="PARAMETER">index_name</REPLACEABLE>" nonexistent</ReturnValue>
+	 </TERM>
+	 <LISTITEM>
+	  <PARA>
+	   This message occurs if it is impossible to drop the index
+	   because it does not exist.
+	  </PARA>
+	 </LISTITEM>
+	</VARLISTENTRY>
+       </variablelist>
+     </LISTITEM>
+    </VARLISTENTRY>
+   </VARIABLELIST>
+  </REFSECT2>
+ </REFSYNOPSISDIV>
+
+ <REFSECT1 ID="R1-SQL-DROPINDEX-1">
+  <REFSECT1INFO>
+   <DATE>1998-04-15</DATE>
+  </REFSECT1INFO>
+  <TITLE>
+   Description
+  </TITLE>
+  <PARA>
+   <command>DROP INDEX</command> drops an existing index from the database
+   system. To execute this command you must be the owner of
+   the index.
+  </PARA>
+  
+  <REFSECT2 ID="R2-SQL-DROPINDEX-3">
+   <REFSECT2INFO>
+    <DATE>1998-04-15</DATE>
+   </REFSECT2INFO>
+   <TITLE>
+    Notes
+   </TITLE>
+   <PARA>
+    <command>DROP INDEX</command> is a PostgreSQL language extension.
+   </PARA>
+   <PARA>
+    Refer to the <command>CREATE INDEX</command> statement for 
+    inforamtion on how to create indexes.
+   </PARA>
+  </REFSECT2>
+  
+ <REFSECT1 ID="R1-SQL-DROPINDEX-2">
+  <TITLE>
+   Usage
+  </TITLE>
+  <PARA>
+   This command will remove the <literal>title_idx</literal> index:
+  </PARA>
+  <ProgramListing>
+   DROP INDEX title_idx;
+  </ProgramListing>
+ </REFSECT1>
+ 
+ <REFSECT1 ID="R1-SQL-DROPINDEX-3">
+  <TITLE>
+   Compatibility
+  </TITLE>
+  <PARA>
+  </PARA>
+  
+  <REFSECT2 ID="R2-SQL-DROPINDEX-4">
+   <REFSECT2INFO>
+    <DATE>1998-04-15</DATE>
+   </REFSECT2INFO>
+   <TITLE>
+    SQL92
+   </TITLE>
+   <PARA>
+    There is no <command>DROP INDEX</command> statement on SQL92.
+   </PARA>
+  </refsect2>
+ </refsect1>
+</REFENTRY>
+
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode: sgml
+sgml-omittag:t
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
+sgml-local-ecat-files:nil
+End:
+-->