Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting Temp Tables
- Thread starter NCYankee1
- Start date
Yes, something like this...
Dim tbls as Tabledefs
Dim tbl as Tabledef
For each tbl in Tbls
if tbl.Name like "Temp*" then
tbls.delete tbl.name
end if
Next tbl
tbls.refresh
Obviously, you will need to debug and adapt this to your code. Hope that helps.
Gary
gwinn7
Dim tbls as Tabledefs
Dim tbl as Tabledef
For each tbl in Tbls
if tbl.Name like "Temp*" then
tbls.delete tbl.name
end if
Next tbl
tbls.refresh
Obviously, you will need to debug and adapt this to your code. Hope that helps.
Gary
gwinn7
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question