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. Use the following syntax to remove a sequence:

Syntax 

DROP SEQUENCE [schema_name.]sequence_name;

Example: DROP SEQUENCE statement

In the following example, the DROP SEQUENCE statement removes the sequence named customer from the pub schema.

DROP SEQUENCE pub.customer;

For more on the DROP SEQUENCE statement, see OpenEdge SQL Reference.