DROP SEQUENCE

DROP SEQUENCE

DROP SEQUENCE sequence_name

DROP SEQUENCE [[catalog_name.]schema_name.]sequence_name

Usage

The DROP SEQUENCE statement removes the specified sequence from the database.

Example

DROP SEQUENCE SEQ1;
-- Using catalog, schema, and sequence name
DROP SEQUENCE bank_db.checking_acct_schema.account_num_seq;