Hi

Thanks for previous help.

I am trying to drop a table in Java and am having trouble with
object tablename is in use message.

Using:
con.setAutoCommit(false);
statement.executeUpdate("DROP TABLE tablename");
con.commit();
con.setAutoCommit(false);

fails on the commit with the message 'object tablename is in use'.

What exactly puts a table 'in use' and what code do you use to take
it 'out of use'.

Thanks