—
NAME
DROP_SEQUENCE - remove a sequence
SYNOPSIS
bash
DROP SEQUENCE [ IF EXISTS ] \nname\n [, ...] [ CASCADE | RESTRICT ]DESCRIPTION
DROP SEQUENCE removes sequence number generators. A sequence can only be dropped by its owner or a superuser.
PARAMETERS
IF EXISTS
name
CASCADE
RESTRICT
EXAMPLES
To remove the sequence serial:
bash
DROP SEQUENCE serial;COMPATIBILITY
DROP SEQUENCE conforms to the SQL standard, except that the standard only allows one sequence to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
CREATE SEQUENCE (CREATE_SEQUENCE(7)), ALTER SEQUENCE (ALTER_SEQUENCE(7))