FirebirdSQL logo
 FILTEREXCEPTION 

Who Can Drop a Sequence?

The DROP SEQUENCE (DROP GENERATOR) statement can be executed by:

  • Administrators

  • The owner of the sequence

  • Users with the DROP ANY SEQUENCE (DROP ANY GENERATOR) privilege

Example of DROP SEQUENCE

Dropping the EMP_NO_GEN series:
DROP SEQUENCE EMP_NO_GEN;
See also

[fblangref50-ddl-sequence-create], [fblangref50-ddl-sequence-crtoralt], [fblangref50-ddl-sequence-recr]