DROP CONNECTION

This page explains how to drop a connection using a SQL command.

This command deletes the specified connection in Upsolver.

If existing tables or jobs are dependent upon the connection, the connection cannot be deleted.

If a connection is dropped, it is no longer visible or usable. However, the credentials provided may continue to be used to finish deleting the data of any recently dropped tables that were created using the connection.

See also:

CREATE CONNECTION, ALTER CONNECTION

Syntax

Drop a connection using a SQL command:

DROP CONNECTION [ IF EXISTS ] <connection_identifier>; 

IF EXISTS

(Optional) To prevent the Upsolver query engine from returning an error if the connection does not exist, include IF EXISTS in your DROP statement; instead, you will see the message Operation resulted in no change.

Example

The following example runs a DROP statement with IF EXISTS to drop the connection, my_test_conn. By including IF EXISTS, an error is not encountered if the connection does not exist. Otherwise, if the connection exists, it will be dropped from the organization:

DROP CONNECTION IF EXISTS "my_test_conn";