DROP CONNECTION Statement

Drops any user connection to the database.

Quick Links:

Go to Parameters

Go to Standards

Go to Permissions

Syntax

DROP CONNECTION connection-id

Parameters

connection-id – obtained using the connection_property function to request the connection number. This statement returns the connection ID of the current connection:
```
SELECT connection_property( 'number' )
```

Examples

Example 1 – drop connection with ID number 4:
```
DROP CONNECTION 4
```

Usage

You cannot drop your current connection; you must first create another connection, then drop your first connection.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
SAP Sybase Database product—Not supported by Adaptive Server.

Permissions

Requires the DROP CONNECTION system privilege.

Parent topic: SQL Statements

Related reference

CONNECT Statement [ESQL] [Interactive SQL]

Created May 13, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com