Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mike Arney One line to drop a (temp) table if it exists RE: One line to drop a (temp) table if it exists

  • April 14, 2009 at 11:18 am

    #977458

    Seems like a nifty trick but I prefer the old fashioned way:

    IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t;