DROP CONNECTION statement
508
DROP CONNECTION statement
Use this statement to drop a connection to the database, belonging to any
user.
DROP CONNECTION
connection-id
Must have DBA authority.
None.
"CONNECT statement" on page 423
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’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ The following statement drops the connection with ID number 4.
DROP CONNECTION 4
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example
To Next Page
Loading...