602SQL Documentation Index  

DROP SEQUENCE Statement

statement_DROP_SEQUENCE :== DROP [ IF EXISTS ] SEQUENCE [scheme.]sequence_name

The DROP SEQUENCE statement deletes a sequence of the specified name from the specified application.

If the sequence of the specified name does not exist in the schema, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

You can also delete a sequence from the the Control Panel of the 602SQL Client.

See