A sequenceName represents a sequence generator. To create a sequence generator, use the CREATE SEQUENCE statement.
[ schemaName. ] SQL92Identifier
You can qualify a sequence name with a schemaName. If a qualified sequence name is specified, the schema name cannot begin with SYS.
DROP SEQUENCE order_id RESTRICT