Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with sequences : DROP SEQUENCE
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:
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.