What happens with a temporary table if the session disconects ok, but without explicitly
dropping the table first?

Dan.

Dan,

<< What happens with a temporary table if the session disconects ok, but
without explicitly dropping the table first? >>

It is dropped automatically by the engine when each database in which the
temporary tables reside is closed by the session (also done automatically).

--
Tim Young
Elevate Software
www.elevatesoft.com