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.
Drop a connection using a SQL command:
DROP CONNECTION [ IF EXISTS ] <connection_identifier>;
(Optional) To prevent the Upsolver query engine from returning an error if the connection does not exist, include
IF EXISTSin your
DROPstatement; instead, you will see the message Operation resulted in no change.
The following example runs a
IF EXISTSto 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";