Adrian,

You do not need to empty the table before you drop it.

Make sure no other process is connected and just drop the table.

Bill Meaney

>
>
>
>I have the next script
>
>DELETE FROM DFACDNCR2 !!
>
>COMMIT !!
>
>DROP TABLE DFACDNCR2 !!
>
>When tries od exceute the next statement
>
>DROP TABLE DFACDNCR2 !!
>
>I get the next error
>
>Table DFACDNCR2 is in use:
>
>Any ideas?
>
>
>
>
>
>
>