Home Explore Blog CI



postgresql

doc/src/sgml/ref/drop_sequence.sgml
62395bde6c58c04ba412cdb3d62bec03c6d34bbdd38aef6b0000000300000a7c
<!--
doc/src/sgml/ref/drop_sequence.sgml
PostgreSQL documentation
-->

<refentry id="sql-dropsequence">
 <indexterm zone="sql-dropsequence">
  <primary>DROP SEQUENCE</primary>
 </indexterm>

 <refmeta>
  <refentrytitle>DROP SEQUENCE</refentrytitle>
  <manvolnum>7</manvolnum>
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>

 <refnamediv>
  <refname>DROP SEQUENCE</refname>
  <refpurpose>remove a sequence</refpurpose>
 </refnamediv>

 <refsynopsisdiv>
<synopsis>
DROP SEQUENCE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
</synopsis>
 </refsynopsisdiv>

 <refsect1>
  <title>Description</title>

  <para>
   <command>DROP SEQUENCE</command> removes sequence number
   generators. A sequence can only be dropped by its owner or a superuser.
  </para>
 </refsect1>

 <refsect1>
  <title>Parameters</title>

  <variablelist>
   <varlistentry>
    <term><literal>IF EXISTS</literal></term>
    <listitem>
     <para>
      Do not throw an error if the sequence does not exist. A notice is issued
      in this case.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">name</replaceable></term>
    <listitem>
     <para>
      The name (optionally schema-qualified) of a sequence.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><literal>CASCADE</literal></term>
    <listitem>
     <para>
      Automatically drop objects that depend on the sequence,
      and in turn all objects that depend on those objects
      (see <xref linkend="ddl-depend"/>).
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><literal>RESTRICT</literal></term>
    <listitem>
     <para>
      Refuse to drop the sequence if any objects depend on it.  This
      is the default.
     </para>
    </listitem>
   </varlistentry>
  </variablelist>
 </refsect1>

 <refsect1>
  <title>Examples</title>

  <para>
   To remove the sequence <literal>serial</literal>:

<programlisting>
DROP SEQUENCE serial;
</programlisting></para>
 </refsect1>

 <refsect1>
  <title>Compatibility</title>

  <para>
   <command>DROP SEQUENCE</command> conforms to the <acronym>SQL</acronym>
   standard, except that the standard only allows one
   sequence to be dropped per command, and apart from the
   <literal>IF EXISTS</literal> option, which is a <productname>PostgreSQL</productname>
   extension.
  </para>
 </refsect1>

 <refsect1>
  <title>See Also</title>

  <simplelist type="inline">
   <member><xref linkend="sql-createsequence"/></member>
   <member><xref linkend="sql-altersequence"/></member>
  </simplelist>
 </refsect1>

</refentry>

Chunks
6d95ec7e (1st chunk of `doc/src/sgml/ref/drop_sequence.sgml`)
Title: DROP SEQUENCE
Summary
This documentation describes the DROP SEQUENCE command in PostgreSQL, which removes sequence number generators. It details the syntax, parameters (including IF EXISTS, CASCADE, and RESTRICT), provides an example, discusses compatibility with the SQL standard, and lists related commands.