August 30, 2001 at 2:34 am
how to drop a temprory table created by command create table #123
thanks in advance
from
alkesh
August 30, 2001 at 4:58 am
doesnt DROP TABLE #123 work???
usually if you're using temp tables in a proc - they are automatically dropped as soon as the execution is complete
September 3, 2001 at 5:13 am
The temporary tables gets dropped automatically once the execution is complete.
Isn't they get dropped?
September 3, 2001 at 10:24 am
Depends on what you call execution. For example, if you create a temp table in Query Analyzer it will exist until you drop it explicitly or you close the window (connection). If you're in a loop of some sort you may need to do the explicit drop. Plus I consider it to be a best practice, right up there with setting objects to nothing.
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy