Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP SEQUENCE

DROP SEQUENCE#

Syntax#

drop_sequence ::=#

drop_sequence_image164

Prerequisites#

Only the SYS user, the owner of the schema containing the sequence, and users with the DROP ANY SEQUENCE system privilege can execute the DROP SEQUENCE statement.

Description#

This statement is used to remove a sequence from the database.

user_name#

This is used to specify the name of the owner of the sequence to be dropped. If omitted, Altibase will assume that the sequence belongs to the schema of the user connected via the current session.

seq_name#

This is used to specify the name of the sequence to drop.

Example#

<Query> Delete the sequence seq1.

iSQL> DROP SEQUENCE seq1;
Drop success.