Dropping Sql Temp tables from Vb.Net

I have a vb.net app , and I am creating and dropping temp tables. I just want to know whether the temp tables created programatica开发者_开发百科lly from some client app will get dropped automatically with dispose of application or we should have to drop it explicitly by code.

I need to be sure that all tables will get dropped when I close my app or that block has been executed successfully.

Right now I am dropping using drop table .... I need code to check existing temp table in sql server and drop them all at a time on form close.

I hope my lines are clear.

Environment is VB.Net + Sql Server 2008

Local Temp tables are disposed of when the session closes.

Global temp tables (with ## prefix) are dropped off when the last connection using it closes.