DROP SEQUENCE

2024-12-02 03:48:26  Updated

Purpose

You can use this statement to drop a sequence.

Syntax

DROP SEQUENCE [schema. ] sequence_name;

Parameters

Parameter Description
schema. The schema where the sequence is located. If schema. is not specified, the sequence is located in the schema of the currently logged-on user.
sequence_name The name of the sequence to be dropped.

Examples

Drop the sequence named seq1.

obclient> DROP SEQUENCE seq1;
Query OK, 0 rows affected

Contact Us