DROP SEQUENCE statement

DROP SEQUENCE statement DROP SEQUENCE statement SQL statementsDROP SEQUENCE sequence generatorsdropping

The DROP SEQUENCE statement removes a sequence generator that was created using a .

Syntax DROP SEQUENCE [ schemaName. ] SQL92Identifier RESTRICT

The sequence name is composed of an optional schemaName and a SQL92Identifier. If a schemaName is not provided, the current schema is the default schema. If a qualified sequence name is specified, the schema name cannot begin with SYS.

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;