Skip to content

DROP SEQUENCE

Grammar Description

DROP SEQUENCE is used to delete sequences. It allows you to delete sequences previously created using the CREATE SEQUENCE command.

Deleting a sequence deletes all attributes and values ​​of the sequence. Therefore, before deleting the sequence, you must make sure that no tables are still using the sequence.

Grammar Structure

> DROP SEQUENCE [ IF EXISTS ] SEQUENCE_NAME [, ...]
  [IF EXISTS]

Example

-- Deleted the sequence named "seq_id"
DROP SEQUENCE seq_id;