DROP CONNECTION

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above Unity Catalog only

Drops a connection. An exception is thrown if the connection does not exist in the metastore. To drop a connection you must have the MANAGE privilege on the connection or be its owner.

Syntax

DROP CONNECTION [ IF EXISTS ] connection_name

Parameters

• IF EXISTS

  If specified, no exception is thrown when the connection does not exist.

• connection_name:

  The name of an existing connection in the metastore. If the name does not exist, an exception is thrown.

Examples

SQL

> DROP CONNECTION mysql_connection;

Related articles

• ALTER CONNECTION
• COMMENT ON CONNECTION
• CREATE CONNECTION
• DESCRIBE CONNECTION
• SHOW CONNECTIONS