I386LINUX/util/I386LINUX/doc/postgresql/html/sql-dropindex.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >DROP INDEX</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="SQL Commands"
  16 HREF="sql-commands.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="DROP GROUP"
  19 HREF="sql-dropgroup.html"><LINK
  20 REL="NEXT"
  21 TITLE="DROP LANGUAGE"
  22 HREF="sql-droplanguage.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="REFENTRY"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="sql-dropgroup.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="sql-dropgroup.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="sql-droplanguage.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="sql-droplanguage.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><H1
  91 ><A
  92 NAME="SQL-DROPINDEX"
  93 ></A
  94 >DROP INDEX</H1
  95 ><DIV
  96 CLASS="REFNAMEDIV"
  97 ><A
  98 NAME="AEN39705"
  99 ></A
 100 ><H2
 101 >Name</H2
 102 >DROP INDEX&nbsp;--&nbsp;remove an index</DIV
 103 ><A
 104 NAME="AEN39708"
 105 ></A
 106 ><DIV
 107 CLASS="REFSYNOPSISDIV"
 108 ><A
 109 NAME="AEN39710"
 110 ></A
 111 ><H2
 112 >Synopsis</H2
 113 ><PRE
 114 CLASS="SYNOPSIS"
 115 >DROP INDEX <VAR
 116 CLASS="REPLACEABLE"
 117 >name</VAR
 118 > [, ...] [ CASCADE | RESTRICT ]</PRE
 119 ></DIV
 120 ><DIV
 121 CLASS="REFSECT1"
 122 ><A
 123 NAME="AEN39713"
 124 ></A
 125 ><H2
 126 >Description</H2
 127 ><P
 128 >   <TT
 129 CLASS="COMMAND"
 130 >DROP INDEX</TT
 131 > drops an existing index from the database
 132    system. To execute this command you must be the owner of
 133    the index.
 134   </P
 135 ></DIV
 136 ><DIV
 137 CLASS="REFSECT1"
 138 ><A
 139 NAME="AEN39717"
 140 ></A
 141 ><H2
 142 >Parameters</H2
 143 ><P
 144 ></P
 145 ><DIV
 146 CLASS="VARIABLELIST"
 147 ><DL
 148 ><DT
 149 ><VAR
 150 CLASS="REPLACEABLE"
 151 >name</VAR
 152 ></DT
 153 ><DD
 154 ><P
 155 >      The name (optionally schema-qualified) of an index to remove.
 156      </P
 157 ></DD
 158 ><DT
 159 ><TT
 160 CLASS="LITERAL"
 161 >CASCADE</TT
 162 ></DT
 163 ><DD
 164 ><P
 165 >      Automatically drop objects that depend on the index.
 166      </P
 167 ></DD
 168 ><DT
 169 ><TT
 170 CLASS="LITERAL"
 171 >RESTRICT</TT
 172 ></DT
 173 ><DD
 174 ><P
 175 >      Refuse to drop the index if any objects depend on it.  This is
 176       the default.
 177      </P
 178 ></DD
 179 ></DL
 180 ></DIV
 181 ></DIV
 182 ><DIV
 183 CLASS="REFSECT1"
 184 ><A
 185 NAME="AEN39735"
 186 ></A
 187 ><H2
 188 >Examples</H2
 189 ><P
 190 >   This command will remove the index <TT
 191 CLASS="LITERAL"
 192 >title_idx</TT
 193 >:
 194
 195 </P><PRE
 196 CLASS="PROGRAMLISTING"
 197 >DROP INDEX title_idx;</PRE
 198 ><P>
 199   </P
 200 ></DIV
 201 ><DIV
 202 CLASS="REFSECT1"
 203 ><A
 204 NAME="AEN39740"
 205 ></A
 206 ><H2
 207 >Compatibility</H2
 208 ><P
 209 >   <TT
 210 CLASS="COMMAND"
 211 >DROP INDEX</TT
 212 > is a
 213    <SPAN
 214 CLASS="PRODUCTNAME"
 215 >PostgreSQL</SPAN
 216 > language extension.  There
 217    are no provisions for indexes in the SQL standard.
 218   </P
 219 ></DIV
 220 ><DIV
 221 CLASS="REFSECT1"
 222 ><A
 223 NAME="AEN39745"
 224 ></A
 225 ><H2
 226 >See Also</H2
 227 ><A
 228 HREF="sql-createindex.html"
 229 ><I
 230 >CREATE INDEX</I
 231 ></A
 232 ></DIV
 233 ><DIV
 234 CLASS="NAVFOOTER"
 235 ><HR
 236 ALIGN="LEFT"
 237 WIDTH="100%"><TABLE
 238 SUMMARY="Footer navigation table"
 239 WIDTH="100%"
 240 BORDER="0"
 241 CELLPADDING="0"
 242 CELLSPACING="0"
 243 ><TR
 244 ><TD
 245 WIDTH="33%"
 246 ALIGN="left"
 247 VALIGN="top"
 248 ><A
 249 HREF="sql-dropgroup.html"
 250 ACCESSKEY="P"
 251 >Prev</A
 252 ></TD
 253 ><TD
 254 WIDTH="34%"
 255 ALIGN="center"
 256 VALIGN="top"
 257 ><A
 258 HREF="index.html"
 259 ACCESSKEY="H"
 260 >Home</A
 261 ></TD
 262 ><TD
 263 WIDTH="33%"
 264 ALIGN="right"
 265 VALIGN="top"
 266 ><A
 267 HREF="sql-droplanguage.html"
 268 ACCESSKEY="N"
 269 >Next</A
 270 ></TD
 271 ></TR
 272 ><TR
 273 ><TD
 274 WIDTH="33%"
 275 ALIGN="left"
 276 VALIGN="top"
 277 >DROP GROUP</TD
 278 ><TD
 279 WIDTH="34%"
 280 ALIGN="center"
 281 VALIGN="top"
 282 ><A
 283 HREF="sql-commands.html"
 284 ACCESSKEY="U"
 285 >Up</A
 286 ></TD
 287 ><TD
 288 WIDTH="33%"
 289 ALIGN="right"
 290 VALIGN="top"
 291 >DROP LANGUAGE</TD
 292 ></TR
 293 ></TABLE
 294 ></DIV
 295 ></BODY
 296 ></HTML
 297 >