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 Data Management: SQL Reference.
