Dropping sequences

Use DROP SEQUENCE to remove a named sequence. For example:

=> DROP SEQUENCE my_sequence;

You cannot drop a sequence if one 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.