At 01:51 PM 17/05/2006, you wrote:

>Trying to drop a table which I created in the same session
>I get the below error.
>What can I Do
>
>- the table is external
>- the table had a stored procedure using it.
>- i have successfully dropped the stored procedure.
>
>ISC ERROR CODE:335544345
>
>ISC ERROR MESSAGE:
>lock conflict on no wait transaction
>unsuccessful metadata update
>object MYTABLE is in use

Stored procedures (and triggers) that you alter or drop nevertheless
remain cached until the last user logs out....so, what you can do is
log everyone out (Superserver) or simply log out yourself if it's Classic.

./heLen