Purpose
This statement is used to drop a sequence.
Syntax
DROP SEQUENCE [schema. ] sequence_name
Parameters
| Parameter | Description |
|---|---|
| schema. | The user who owns the sequence. If you do not specify Schema, the sequence of the current user is dropped. |
| sequence_name | The name of the sequence to be dropped. |
Examples
Example of creating and dropping a sequence.
obclient> CREATE SEQUENCE employee_id_seq
START WITH 1000
INCREMENT BY 1;
obclient> DROP SEQUENCE employee_id_seq;