The DROP SEQUENCE statement removes a sequence generator that was created using a CREATE SEQUENCE statement.
DROP SEQUENCE sequenceName RESTRICT
The RESTRICT keyword is required. If a trigger or view references the sequence generator, Derby throws an exception.
Dropping a sequence generator implicitly drops all USAGE privileges that reference it.
DROP SEQUENCE order_id RESTRICT;