SQL判断临时表是否存在

IF EXISTS(select * from tempdb..sysobjects where id=object_id('tempdb..#tb'))
BEGIN
    DROP TABLE #tb
END
原文地址:https://www.cnblogs.com/allen0118/p/3872966.html