DROP DATA CONNECTION

The DROP DATA CONNECTION statement deletes a data connection. Dropping a data connection affects all existing mappings where the data connection is in use, but will not affect any queries that are already running.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the DROP DATA CONNECTION statement.

See some practical examples.

sql

DROP DATA CONNECTION [IF EXISTS] data_connection_name

Parameters

The DROP DATA CONNECTION statement accepts the following parameters.

The data_connection_name parameter is required.

Parameter	Description	Example
IF EXISTS	Do nothing if the data connection either does not exist or is no longer running.	Delete a Data Connection
data_connection_name	The name of the data connection to delete.	Delete a Data Connection

Examples

This section lists some example SQL queries that show you how to use the DROP DATA CONNECTION statement.

Delete a Data Connection

sql

DROP DATA CONNECTION IF EXISTS myKafkaSource;