ASA SQL Reference
  SQL Statements

DROP CONNECTION statement

Description 

Use this statement to drop a connection to the database, belonging to any user.

Syntax 

DROP CONNECTION connection-id

Usage 

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

You can obtain the connection-id by 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' )

Permissions 

Must have DBA authority.

Side effects 

None.

See also 

CONNECT statement [ESQL] [Interactive SQL]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement drops the connection with ID number 4.

DROP CONNECTION 4