sequenceName

A sequenceName represents a sequence generator. To create a sequence generator, use the CREATE SEQUENCE statement.

Syntax

[ schemaName. ] SQLIdentifier

You can qualify a sequence name with a schemaName. If a qualified sequence name is specified, the schema name cannot begin with SYS.

Example

DROP SEQUENCE order_id RESTRICT