Background documentationDROP SEQUENCE Statement (drop_sequence_statement) Locate this document in the navigation structure

 

The DROP SEQUENCE statement (drop_sequence_statement) deletes a number generator (sequence).

Structure

Syntax Syntax

  1. <drop_sequence_statement> ::=
  DROP SEQUENCE [<schema_name>.]<sequence_name>
End of the code.
Examples

SQL Tutorial, Number Generators for Tables

Explanation

The current database user must be the owner of the sequence or have the DROPIN privilege for the schema to which the sequence to be dropped is assigned.

The metadata of the sequence is removed from the database catalog.

More Information

Privileges: Overview