How to unlock table in sybase?

问题:

im trying to change some types on my table in sybase, but when i change it, the output is this one.

User 'DBA' has the row in 'table' locked

How to unlock this?

回答1:

I would:

1. determine the connection_id using sa_locks (documentation here)
2. issue the drop connection *connection_id* statement to the connection that is causing the lock to the table.

Use it with care!