Name
DROP SEQUENCE -- Removes a sequence from a database.
Synopsis
DROP SEQUENCE
name
[, ...]
Parameters
-
name
-
The name of the sequence you wish to permanently remove. You may drop multiple sequences by specifying their names in a comma-delimited list.
Results
-
DROP
-
The message returned when a sequence is successfully dropped.
-
ERROR: sequence "
name
" does not exist
-
The error returned if the specified sequence
name
does not exist.
Description
Use the DROP SEQUENCE command to remove a sequence number generator from a database.
Example
The following example removes a sequence named shipments_ship_id_seq from the database:
booktown=#
DROP SEQUENCE shipments_ship_id_seq;
DROP
