You can use below command to drop / disconnect user from the Sybase IQ database. At first, you must know the connection ID.
1. To get the connection ID, use below command – the command will output the conn_id.
sp_iqlocks;
1. Next, execute the drop command,
drop connection [CONNECTION-ID]
