> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/query/terminate-query.md).

# TERMINATE QUERY

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
TERMINATE QUERY [query_id | query_name[:query_version]];
```

## Description <a href="#description" id="description"></a>

`TERMINATE QUERY` stops and deletes the query specified by `query_id`. Note that this does not delete any entity or relation created by the query.

{% hint style="warning" %}
`TERMINATE QUERY` cannot be undone. Use it with care! When a query is terminated, it is deleted and cannot be restarted. You can only recreate the terminated query by using one of the [Query](/reference/sql-syntax/query.md) statements.
{% endhint %}

See [LIST QUERIES](/reference/sql-syntax/command/list-queries.md) for accessing terminated queries.

Queries are visible only if the current [Access Control](/overview/core-concepts/access-control.md#role) has `USAGE` privileges on them.

### Arguments <a href="#parameters" id="parameters"></a>

#### query\_id

This is the unique identifier of the Query to terminate. See [LIST QUERIES](https://github.com/deltastreaminc/ds-docs-gitbook/blob/main-dcap/reference/sql-syntax/query/list-queries.md) to find out how to list all Queries that the user has access to. The first column (`ID`) in the response corresponds with the `query_id`.

#### query\_name

This is the name of the Query to terminate. See [LIST QUERIES](https://github.com/deltastreaminc/ds-docs-gitbook/blob/main-dcap/reference/sql-syntax/query/list-queries.md) to find out how to list all Queries that the user has access to. The column (`Name`) in the response corresponds with the `query_name`. The `query_version` property disambiguates between multiple queries with the same name.

#### query\_version

This is the version of the Query to terminate. See [LIST QUERIES](https://github.com/deltastreaminc/ds-docs-gitbook/blob/main-dcap/reference/sql-syntax/query/list-queries.md) to find out how to list all Queries that the user has access to. The column (`Version`) in the response corresponds with the `query_version`. If `query_name` is provided without a `query_version`, the latest `query_version` will be used.

## Examples

#### Terminate a Query

The following is an example of how to terminate a Query. Note the `ID` from `LIST QUERIES` is the same as the `query_id` used in `TERMINATE QUERY`.

```sh
demo_db.public/demostore# LIST QUERIES;
+--------------------------------------+-----------+----------+-----------------+---------------+-------------------------------+----------+-------------------------------+-------------------------------+
|  ID                                  |    Name   |  Version |  Intended State |  Actual State |  Query                        |  Owner   |  Created At                   |  Updated At                   |
+======================================+-----------+----------+=================+===============+===============================+==========+===============================+===============================+
| f6a96114-625a-4ea4-a0d9-46b7c5ababbc | demoquery |        1 | running         | running       | CREATE STREAM pageviews2 AS   | sysadmin | 2023-02-08 22:08:25 +0000 UTC | 2023-02-08 22:08:25 +0000 UTC |
|                                      |           |          |                 |               | SELECT * FROM pageviews;      |          |                               |                               |
+--------------------------------------+-----------+----------+-----------------+---------------+-------------------------------+----------+-------------------------------+-------------------------------+

demo_db.public/demostore# TERMINATE QUERY f6a96114-625a-4ea4-a0d9-46b7c5ababbc;
+-------+--------------------------------------+----------+------------------------------------------+
|  Type |  Name                                |  Command |  Summary                                 |
+=======+======================================+==========+==========================================+
| query | f6a96114-625a-4ea4-a0d9-46b7c5ababbc | DROP     | query                                    |
|       |                                      |          | f6a96114-625a-4ea4-a0d9-46b7c5ababbc     |
|       |                                      |          | was marked for termination               |
+-------+--------------------------------------+----------+------------------------------------------+

demo_db.public/demostore# TERMINATE QUERY demoquery:1;
+-------+--------------------------------------+----------+------------------------------------------+
|  Type |  Name                                |  Command |  Summary                                 |
+=======+======================================+==========+==========================================+
| query | f6a96114-625a-4ea4-a0d9-46b7c5ababbc | DROP     | query                                    |
|       |                                      |          | f6a96114-625a-4ea4-a0d9-46b7c5ababbc     |
|       |                                      |          | was marked for termination               |
+-------+--------------------------------------+----------+------------------------------------------+
```