Deletes a sequence.

Syntax

DROP SEQUENCE name [, ...]

Description

You can use the DROP SEQUENCE command to delete sequence number generators. To run this command on a sequence, you must be a superuser or the owner of the sequence.

Parameters

ParameterDescription
Parameter Description
name The name of a sequence. The name can be schema-qualified.

Examples

Delete the serial sequence: 

DROP SEQUENCE serial;