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;