Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/drop-connection below:

DROP CONNECTION | Snowflake Documentation

Removes a connection from the account.

See also:

CREATE CONNECTION , ALTER CONNECTION , SHOW CONNECTIONS

DROP CONNECTION [ IF EXISTS ] <name>

Copy

name

Specifies the identifier for the connection to drop.

• Only account administrators (users with the ACCOUNTADMIN role) can execute this SQL command.

• A primary connection can’t be dropped if it has one or more secondary connections. To drop the primary connection, first promote a secondary connection to serve as the primary connection, and then drop the former primary connection. Alternatively, drop all of the secondary connections, and then drop the primary connection.

• When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

Drop a connection:

SHOW CONNECTIONS LIKE 't2%';


DROP CONNECTION t2;


SHOW CONNECTIONS LIKE 't2%';

Copy

Drop the connection again, but don’t raise an error if the connection doesn’t exist:

DROP CONNECTION IF EXISTS t2;

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4