January 2002
Intermediate to advanced
640 pages
16h 39m
English
Removes a sequence from a database.
DROP SEQUENCE name [, ...]nameThe name of the sequence you wish to permanently remove. You may drop multiple sequences by specifying their names in a comma-delimited list.
DROPThe message returned when a sequence is successfully dropped.
ERROR: sequence "name" does not existThe error returned if the specified sequence name does not exist.
Use the DROP SEQUENCE command to remove a sequence number generator
from a database.
The following example removes a sequence named shipments_ship_id_seq
from the database:
booktown=# DROP SEQUENCE shipments_ship_id_seq;
DROP