DROP_SEQUENCE(l)                                 DROP_SEQUENCE(l)

NAME
       DROP SEQUENCE - Removes an existing sequence

SYNOPSIS
       DROP SEQUENCE name [, ...]

   INPUTS
       name   The name of a sequence.

   OUTPUTS
       DROP   The  message  returned  if the sequence is success-
              fully dropped.

       WARN: Relation "name" does not exist.
              This message occurs if the specified sequence  does
              not exist.

DESCRIPTION
       DROP  SEQUENCE removes sequence number generators from the
       data base. With the current implementation of sequences as
       special  tables  it  works just like the DROP TABLE state-
       ment.

   NOTES
       The DROP SEQUENCE statement is a Postgres language  exten-
       sion.

       Refer  to the CREATE SEQUENCE statement for information on
       how to create a sequence.

USAGE
       To remove sequence serial from database:

       DROP SEQUENCE serial;

COMPATIBILITY
   SQL92
       There is no DROP SEQUENCE in SQL92.

SQL - Language Statements 15 August 1999                        1