Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → DROP SEQUENCE
Firebird Home Firebird Home Prev: DROP PROCEDUREFirebird Documentation IndexUp: DDL statementsNext: DROP TRIGGER

DROP SEQUENCE

Tip

Find a more recent version at Firebird 5.0 Language Reference: SEQUENCE (GENERATOR)

Available in: DSQL

Added in: 2.0

Description: Removes a sequence or generator from the database. Its (very small) storage space will be freed for re-use after a backup-restore cycle. SEQUENCE is the SQL-compliant term for what InterBase and Firebird have always called a generator. DROP SEQUENCE is fully equivalent to DROP GENERATOR and is the recommended syntax from Firebird 2.0 onward.

Syntax: 

DROP SEQUENCE sequence-name

Example: 

drop sequence seqtest

See also: CREATE SEQUENCE

Prev: DROP PROCEDUREFirebird Documentation IndexUp: DDL statementsNext: DROP TRIGGER
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → DROP SEQUENCE