DROP SEQUENCE

Removes the specified named sequence number generator.

Syntax

DROP SEQUENCE [schema.]sequence‑name[,...]

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
sequence‑name

Specifies the sequence to drop.

Privileges

One of the following:

Restrictions

Example

The following command drops the sequence named sequential.

=> DROP SEQUENCE sequential;