Reference Manual
   CHAPTER 9. SQL Statements     

DROP CONNECTION statement

Function 

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

Syntax 

DROP CONNECTION connection-id

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.

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' )

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported by Adaptive Server Enterprise.

Example 

• The following statement drops the connection with ID number 4.

  DROP CONNECTION 4