# DROP PIPELINE

The `DROP PIPELINE` command deletes a pipeline from your SingleStore cluster. If the pipeline is currently running, it will stop it before deleting it.

## Syntax

```sql
DROP PIPELINE [IF EXISTS] pipeline_name;

```

## Remarks

* After a pipeline has been dropped, any data related to the pipeline will also be deleted from the `information_schema` tables associated with the Pipelines feature.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* The background tasks of a pipeline runs in its resource pool. Therefore, a resource pool used by a pipeline cannot be dropped.

  For more information on resource pools, see [Set Resource Limits](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits.md).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

> **⚠️ Warning**: If a pipeline is dropped and recreated, the pipeline will start reading from the earliest offset in the data source, once the pipeline is started. This may cause duplicate records to be inserted into the destination table(s).

## Example

```sql
SHOW PIPELINES;


```

```output

+-------------------------+---------+
| Pipelines_in_mydatabase | State   |
+-------------------------+---------+
| quickstart_kafka        | Running |
+-------------------------+---------+

```

```sql
DROP PIPELINE quickstart_kafka;
Query OK, 0 rows affected (0.00 sec)

```

```sql
SHOW PIPELINES;
Empty set (0.00 sec)
```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/pipelines-commands/drop-pipeline/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/drop-pipeline/)

(An index of the documentation is available at /llms.txt)