Forcing a delete of a table even if a program is connected.

Hello All,

Is it possible to force a delete of a table even when another program is using that DB, and still has some view data on that specific table.

I know that I can delete tables if another program is just have connection to the DB, but not using the specific table I'd like to delete. Can it be done also on a viewed table?

You cannot delete (or alter) a table if there is an open cursor on it: the engine refuses to do so.

|||

Thanks for your answer,

If so, is there a way to force a complete disconnect of a specific DB, then to delete the table?

|||Not that I know of...