Purpose
This statement is used to drop a sequence.
Syntax
DROP SEQUENCE [schema. ] sequence_name
Parameters
| Parameter | Description |
|---|---|
| schema. | Specifies the user who owns the sequence. If you do not specify Schema, the sequence of the current login user is used by default. |
| sequence_name | Specifies 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;