# STOP PIPELINE

The `STOP PIPELINE` statement stops a currently running pipeline in a SingleStore database.

## Syntax

```sql
STOP PIPELINE [IF RUNNING] pipeline_name [DETACH];
STOP ALL PIPELINES;

```

## Arguments

**pipeline\_name**

The name of the pipeline.

**ALL**

When `ALL` is used in the `STOP PIPELINE` command, all pipelines will stop in the current database.

## Remarks

* An error will occur if the pipeline is not already running, unless `IF RUNNING` is specified, in which case the command is ignored.
* To stop all pipelines in the current database, run `STOP ALL PIPELINES`.
* 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.
* Use the `DETACH` option to temporarily stop a pipeline, without losing offsets, for performing an `ALTER` on the table that is loaded from an Avro pipeline. See [Avro Schema Evolution with Pipelines](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-avro-files/avro-schema-evolution-with-pipelines.md) for details.
* To stop a pipeline, a user must have the `START PIPELINE` permission. Pipelines without the required user access will be skipped and see a message similar to the one below:
  ```sql
  STOP ALL PIPELINES;


  ```
  ```output

  STOP PIPELINE test_pipeline;
  ERROR 1142 (42000): STOP PIPELINE command denied to user 'singlestore-4100c00-bd00-0d'@'%' for table 'test_pipeline'
  ```
* 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.

## Examples

## Example 1: Stop Pipeline

```sql
STOP PIPELINE mypipeline;
```

To verify that the pipeline was successfully stopped, you can execute `SHOW PIPELINES`:

```sql
SHOW PIPELINES;


```

```output

+-------------------+---------+
| Pipelines_in_mydb | State   |
+-------------------+---------+
| mypipeline        | Stopped |
+-------------------+---------+
1 row in set (0.00 sec)

```

## Example 2: Stop All Pipelines

```sql
STOP ALL PIPELINES;
```

To verify that the pipeline was successfully stopped, you can execute `SHOW PIPELINES`:

```sql
SHOW PIPELINES;


```

```output

+-----------------------+---------+-----------+
| Pipelines_in_examples | State   | Scheduled |
+-----------------------+---------+-----------+
| nfbooks               | Stopped | False     |
| books                 | Stopped | False     |
+-----------------------+---------+-----------+
```

***

Modified at: February 15, 2023

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

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