Disconnect from a database by using the DISCONNECT statement or other users by using the DROP CONNECTION statement.
You do not need any privileges to disconnect from the database.
You must have the DROP CONNECTION system privilege to disconnect other users.
Connect to the database.
|Disconnect the current user||
Execute a DISCONNECT statement.
|Disconnect another user||
Use the sa_conn_info system procedure to determine the connection ID of the user you want to disconnect.
Execute a DROP CONNECTION statement.
The following statement disconnects the current connection, conn1, in Interactive SQL:
The following statement shows how to use DISCONNECT in embedded SQL:
EXEC SQL DISCONNECT :conn-name
The following statement drops connection number 4:
DROP CONNECTION 4;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|