FirebirdSQL logo
 FILTEREXCEPTION 

Example of CREATE OR ALTER SEQUENCE

Create a new or modify an existing sequence EMP_NO_GEN
CREATE OR ALTER SEQUENCE EMP_NO_GEN
  START WITH 10
  INCREMENT BY 1
See also

[fblangref50-ddl-sequence-create], [fblangref50-ddl-sequence-alter], [fblangref50-ddl-sequence-drop], [fblangref50-ddl-sequence-recr], [fblangref50-ddl-sequence-setgen], NEXT VALUE FOR, GEN_ID() function

DROP SEQUENCE

Drops a SEQUENCE (GENERATOR)

Available in

DSQL, ESQL

Syntax
DROP {SEQUENCE | GENERATOR} seq_name
Table 1. DROP SEQUENCE Statement Parameter
Parameter Description

seq_name

Sequence (generator) name.The maximum length is 63 characters

The statements DROP SEQUENCE and DROP GENERATOR statements are equivalent: both drop (delete) an existing sequence (generator).Either is valid but DROP SEQUENCE, being defined in the SQL standard, is recommended.

The statements will fail if the sequence (generator) has dependencies.