> > Do I need to do an explicit drop to remove the temporary table?
>
> Yes.

If 'drop' meaning that 'delete rows', then: No.

When you leave transaction/connection pages of temp table will free.
Only table definition stored after temp table used.

eMeL


(ps: sorry for my english)