# **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**

```sql
DROP SEQUENCE [ IF EXISTS ] SEQUENCE_NAME [, ...]
  [IF EXISTS]
```

## **Example**

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