DROP CONNECTION

Purpose

Use this statement to drop an external connection.

Perquisite

You need to have the system privilege DROP ANY CONNECTION or the connection must be granted to the user with the WITH ADMIN OPTION.

Syntax

drop_connection::=

Drop Connection

Usage Notes

  • If the optional IF EXISTS clause is specified, then the statement does not throw an exception if the connection does not exist.

Example

DROP CONNECTION my_connection;