User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To drop a connection to the database, belonging to any user.

Syntax

     DROP CONNECTION connection-id

Usage

Anywhere. You must be connected to the same database on the same server as the connection ID to execute this statement.

Permissions

Must have DBA authority.

Side effects

None.

See also

• CONNECT statement

Description

The DROP CONNECTION statement disconnects a user from the database by dropping the connection to the database.

The connection-id for the connection is obtained using the connection_property function to request the connection number. The following statement returns the connection ID of the current connection:

     SELECT connection_property( 'number' )

Example

The following statement drops connection with ID number 4.

     DROP CONNECTION 4