How to Drop Connection in Sybase IQ



Share this article :

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]

Related posts

User 'another user' has the row in 'ITSITI' locked
How to Get Table Size in Sybase IQ
How to Move Sybase IQ Table to Another DBspace
Sybase IQ IQ_SYSTEM_MAIN Out of Space
© 2018 ITsiti. All Rights Reserved
Powered by KEEM