ContextQMD
Back to Materialize

DROP SINK

doc/user/content/sql/drop-sink.md

123780 B
Original Source

DROP SINK removes a sink from Materialize.

{{% kafka-sink-drop %}}

Syntax

mzsql
DROP SINK [IF EXISTS] <sink_name>;
Syntax elementDescription
IF EXISTSOptional. If specified, do not return an error if the specified sink does not exist.
<sink_name>The sink you want to drop. You can find available sink names through SHOW SINKS.

Examples

mzsql
SHOW SINKS;
nofmt
my_sink
mzsql
DROP SINK my_sink;
nofmt
DROP SINK

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/drop-sink" %}}