DROP SEQUENCE v16

Name

DROP SEQUENCE  Remove a sequence.

Synopsis

DROP SEQUENCE <name> [, ...]

Description

DROP SEQUENCE removes sequence number generators. To execute this command, you must be a superuser or the owner of the sequence.

Parameters

name

The name (optionally schema-qualified) of a sequence.

Examples

Remove the sequence serial:

DROP SEQUENCE serial;

See also

ALTER SEQUENCE, CREATE SEQUENCE