Dropping Sequences

To drop a sequence, use either the SQL Developer navigation frame and Drop tool, or the DDL statement DROP SEQUENCE.

Caution: Do not drop the sequence that you created in "Tutorial: Creating a Sequence"—you need it for later tutorials. If you want to practice dropping sequences, create new ones and then drop them.

To drop a sequence using the Drop tool:

On the Connections tab, expand hr_conn.

Under the hr_conn icon, a list of schema object types appears.
Expand Sequences.

A list of sequences appears.
Right-click the name of the sequence to drop.

A list of choices appears.
Click Drop.

The Drop window opens.
Click Apply.

The Confirmation window opens.
Click OK.

Dropping Sequences

Related Topics