DROP SEQUENCE SQL - Language Statements DROP SEQUENCE remove a sequence 1999-07-20 DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ] 1998-09-22 name The name (optionally schema-qualified) of a sequence. CASCADE Automatically drop objects that depend on the sequence. RESTRICT Refuse to drop the sequence if there are any dependent objects. This is the default. 1998-09-22 DROP SEQUENCE 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 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 The DROP SEQUENCE statement is a PostgreSQL language extension. Refer to the CREATE SEQUENCE statement for information on how to create a sequence. To remove sequence serial from database: DROP SEQUENCE serial; 1998-09-22 There is no DROP SEQUENCE in SQL92.