DROP SEQUENCE statement

DROP SEQUENCE statement The DROP SEQUENCE statement removes the specified sequence generator. DROP SEQUENCE statement SQL statementsDROP SEQUENCE sequence generatorsdropping

A sequence generator is created by a .

Syntax DROP SEQUENCE sequenceName RESTRICT

The RESTRICT keyword is required. If a trigger or view references the sequence generator, throws an exception.

Dropping a sequence generator implicitly drops all USAGE privileges that reference it.

Example DROP SEQUENCE order_id RESTRICT;