Switch to: V9V8V7V6V5

DROP SEQUENCE

DROP SEQUENCE command allows to delete a sequence from the database.

Syntax

drop_table_statement
    :    DROP SEQUENCE [IF EXISTS] sequence_name

Arguments

[IF EXISTS]

Do not raise error in case there is no sequence with the specified name.

table_name

The name of sequence to be deleted.

Examples

DROP SEQUENCE seqPersonID;