The DROP SEQUENCE statement removes a sequence from a schema. The sequence can be in a user's schema or another schema may be specified. You must have DBA privileges to remove a sequence in a schema other than your own.

If a multi-tenant sequence is dropped, then the DROP SEQUENCE statement drops the sequence instance for every tenant defined in the multi-tenant table.

Syntax

DROP SEQUENCE [schema_name ]sequence_name;

Parameters

schema_name

Specifies the schema name that contains the sequence. If this is not specified, OpenEdge SQL drops the sequence.

sequence_name

Specifies the name of the sequence to be dropped.

Example

The following is an example of the DROP SEQUENCE statement: 

DROP SEQUENCE pub.customer;