DROP CONNECTION

Purpose

Use this statement to drop an external connection.

Prerequisite

At least one of the following prerequisites must be fulfilled:

  • User has the system privilege DROP ANY CONNECTION
  • The connection is granted to the user with the WITH ADMIN OPTION
  • The connection belongs to the current user or one of the user’s roles

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;