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:
