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.

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

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

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

DROP DATA CONNECTION IF EXISTS myKafkaSource;