<< SET GENERATOR | FB 2.5 Language Reference | DROP GENERATOR >>
<< SET GENERATOR | FB 2.1 Language Reference | DROP GENERATOR >>
<< DROP PROCEDURE | FB 2.0 Language Reference | DROP TRIGGER >>

DROP SEQUENCE

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:
DROP GENERATOR
CREATE SEQUENCE
ALTER SEQUENCE
NEXT VALUE FOR
DDL - Data Definition Language

back to top of page
<< SET GENERATOR | FB 2.5 Language Reference | DROP GENERATOR >>
<< SET GENERATOR | FB 2.1 Language Reference | DROP GENERATOR >>
<< DROP PROCEDURE | FB 2.0 Language Reference | DROP TRIGGER >>