DROP PAYLOAD TRANSFORM

Permanently deletes a payload transform definition. The target table and any DLQ table are not affected.

Syntax

DROP PAYLOAD TRANSFORM [ IF EXISTS ] transformName

Parameter	Description
`transformName`	Name of the payload transform to drop
`IF EXISTS`	Suppress error if the transform does not exist

Drop a payload transform

DROP PAYLOAD TRANSFORM binance_depth;

Drop only if exists (no error if missing)

DROP PAYLOAD TRANSFORM IF EXISTS binance_depth;

Aspect	Description
Target table	Not affected - existing data remains
DLQ table	Not affected - existing error rows remain
Active requests	In-flight `/ingest` requests may still complete

Enterprise

In QuestDB Enterprise deployments with RBAC enabled, the user must hold the DROP PAYLOAD TRANSFORM grant.

GRANT DROP PAYLOAD TRANSFORM TO ingest_admin;