DROP SEQUENCE

    Description

    removes a sequence generator table. You must own the sequence to drop it (or be a superuser).

    IF EXISTS

    Do not throw an error if the sequence does not exist. A notice is issued in this case.

    The name (optionally schema-qualified) of the sequence to remove.

    CASCADE

    Automatically drop objects that depend on the sequence.

    Refuse to drop the sequence if any objects depend on it. This is the default.

    Examples

    Remove the sequence :

    is fully conforming with the SQL standard, except that the standard only allows one sequence to be dropped per command. Also, the option is a Greenplum Database extension.

    See Also

    Parent topic: SQL Command Reference