Dropping Sequences

Use DROP SEQUENCE to remove a named sequence. You cannot drop a sequence in if any of the following conditions is true:

• Other objects depend on the sequence. DROP SEQUENCE does not support cascade operations.
• A column's DEFAULT expression references the sequence. Before dropping the sequence, you must remove all column references to it.

Example

The following command drops the sequence named my_sequence:

=> DROP SEQUENCE my_sequence;