DROP SEQUENCE
SQL - Language Statements
DROP SEQUENCE
Removes existing sequences from a database
1999-07-20
DROP SEQUENCE name [, ...]
1998-09-22
Inputs
name
The name of a sequence.
1998-09-22
Outputs
DROP
The message returned if the sequence is successfully dropped.
ERROR: sequence "name" does not exist
This message occurs if the specified sequence does not exist.
1998-09-22
Description
DROP SEQUENCE removes sequence number generators from the
data base. With the current implementation of sequences as
special tables it works just like the DROP TABLE
statement.
1998-09-22
Notes
The DROP SEQUENCE statement is a
Postgres
language extension.
Refer to the CREATE SEQUENCE statement for
information on how to create a sequence.
Usage
To remove sequence serial from database:
DROP SEQUENCE serial;
Compatibility
1998-09-22
SQL92
There is no DROP SEQUENCE in SQL92.