DROP SEQUENCE

Issue the DROP SEQUENCE command to drop a sequence.

Syntax

Syntax for dropping a sequence:

DROP SEQUENCE <seq_name>

Input

The DROP SEQUENCE command takes the following input:

Table 1. DROP SEQUENCE input
Input	Description
<seq_name>	The name of the sequence to be dropped.

Output

The DROP SEQUENCE command produces the following output:

Table 2. DROP SEQUENCE output
Output	Description
`DROP SEQUENCE`	The command was successful.

Privileges

You must be the admin user, the owner of the sequence, the owner of the database or the schema where the sequence is defined, or your account must have Drop privileges on the sequence or the Sequence object class.

Usage

The following provides sample usage:

To drop the sequence sequence1:

MYDB.SCH1(USER)=> DROP SEQUENCE sequence1;