disconnect

Drops the current connection to a database.

Syntax

disconnect [{identifier | string | hostvar} | current | all]

Parameters

Examples

Usage

disconnect drops a connection to the database server and releases all resources used by it. If the connection to be dropped was named on the connect statement, the name can be specified. Specifying all drops all of the application’s connections to all database environments. current is the default, and drops the current connection.

An implicit rollback is executed on connections that are dropped.

Permissions

Any user can execute this command.

Related reference
connect
set connection