Dropping Sequences

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

Example

The following command drops the sequence named my_sequence:

=> DROP SEQUENCE my_sequence;