The DROP SEQUENCE statement removes the specified sequence generator.
A sequence generator is created by 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;