开发者

Dropping Sql Temp tables from Vb.Net

开发者 https://www.devze.com 2022-12-29 06:25 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消