In this blog post, you’ll learn more about the Sybase Error The object cannot be opened for DROP or ALTER. It is already open. %1 and the reason for receiving this error
Sybase SQL Error Message
The object cannot be opened for DROP or ALTER. It is already open. %1
Reason for this Error
The object that you have requested to DROP or ALTER cannot be opened for META access. Either the current connection or another connection has a cursor open on the table you are trying to DROP or ALTER or on the table to which the field or index you are trying open for META belongs. In order to proceed, all cursors open on this object must be closed.