DROP SEQUENCE SQL - Language Statements DROP SEQUENCE Removes an existing sequence 1998-04-15 DROP SEQUENCE seqname [, ...] 1998-04-15 Inputs seqname The name of a sequence. 1998-04-15 Outputs DROP The message returned if the sequence is successfully dropped. WARN: Relation "seqname" does not exist. This message occurs if the sequence specified does not exist. 1998-04-15 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-04-15 Notes The DROP SEQUENCE statement is a PostgreSQL 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-04-15 SQL92 There is no DROP SEQUENCE statement in SQL92.