---
metadata:
  - name: generator
    content: Diplodoc Platform v5.52.0
alternate:
  - https://ydb.tech/docs/en/yql/reference/syntax/drop-transfer.md?version=v26.1
  - https://ydb.tech/docs/ru/yql/reference/syntax/drop-transfer.md?version=v26.1
  - href: en/yql/reference/syntax/drop-transfer.md
    type: text/markdown
    title: Markdown version
  - href: ../../../llms.txt
    type: text/markdown
    title: llms.txt
sourcePath: en/core/yql/reference/syntax/drop-transfer.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# DROP TRANSFER

The `DROP TRANSFER` statement deletes a [transfer](https://ydb.tech/docs/en/concepts/transfer.md?version=v26.1) instance. If a [consumer](https://ydb.tech/docs/en/concepts/datamodel/topic.md?version=v26.1#consumer) was created automatically when the transfer was created, it is also deleted. The system will keep trying to delete the consumer until the operation is successful.

The `DROP TRANSFER` statement does not delete the destination table or the source topic.

## Syntax {#syntax}

```yql
DROP TRANSFER <name>
```

where:

* `name` — the name of the transfer instance.

## Permissions

The following [permissions](https://ydb.tech/docs/en/yql/reference/syntax/grant.md?version=v26.1#permissions-list) are required to delete a transfer:

* `REMOVE SCHEMA` — to delete the transfer instance;
* `ALTER SCHEMA` — to delete the automatically created topic consumer (if applicable).

## Examples {#examples}

The following query deletes the transfer named `my_transfer`:

```yql
DROP TRANSFER my_transfer;
```

## See Also

* [CREATE TRANSFER](https://ydb.tech/docs/en/yql/reference/syntax/create-transfer.md?version=v26.1)
* [ALTER TRANSFER](https://ydb.tech/docs/en/yql/reference/syntax/alter-transfer.md?version=v26.1)
* [Data transfer](https://ydb.tech/docs/en/concepts/transfer.md?version=v26.1)