Disconnecting Other Users From a Database

SAP Sybase IQ gives you the ability to disconnect other users from a given database.

You can obtain the connection-id for a user 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' )
  1. Connect to an existing database as a user with administrative authority over the DROP CONNECTION system privilege.
  2. Using Interactive SQL, execute a DROP CONNECTION statement.

    The following statement drops the connection with ID number 4.

    DROP CONNECTION 4
Parent topic: Create and Manage SAP Sybase IQ Databases